Erik Porter's Blog

Life and Development at Microsoft and Other Technology Discussions

News

    SQL Server 2005 Developer Edition Slowness

    I'm at home this weekend slamming out some code for fun using SQL Server 2005 and Visual Studio 2005.  It's a lot of fun and it's great to finally get to use the RTM bits to build an application.  I noticed though that on my machine (XP SP2) SQL Server takes a lot longer to start up than SQL Server 2000 did.  The problem with that is that it holds up my machine from loading up everything else.  I also noticed that my memory usage is way up from what it used to be (pre SQL2K5).  I haven't played around with turning things on and off to find out what it might be yet.  I'm just curious, has anyone else noticed this.  If so, what things have you turned off by default to help?
    Posted: Oct 30 2005, 07:46 PM by HumanCompiler | with 10 comment(s)
    Filed under:

    Comments

    Raj Kaimal said:

    What components did you install?
    It loads fine on mine. Sqlserver.exe takes up apprx 66MB while SQLAGENT90.exe takes up apprx 1.7MB

    I installed the following:
    Sql Server Database Services
    Workstation components, Books Online and Development tools

    After install, I turned off SQL FullText search.

    Analysis, reporting, notification, integration services might be taking up a lot of resources if you have those installed.
    # October 31, 2005 12:16 AM

    Erik Porter said:

    Thanks, Raj.

    I installed everything by default. I'll just start turning things off and see how it goes...thanks.
    # October 31, 2005 12:17 AM

    scottgu said:

    Do you have any managed components running? Those would load the CLR, which would impact first time loading as well as potentially increase working set.

    Hope this helps,

    Scott
    # October 31, 2005 12:30 AM

    Erik Porter said:

    Actually, I don't, Scott. However, I AM working on a couple CLR SP's so that's good to know down the road, thanks!
    # October 31, 2005 12:32 AM

    Frans Bouma said:

    What I've noticed on my laptop is that with the CTP bits of sqlserver 2005, logging in took 2 minutes longer (there was a 2 minute delay before everything showed up.) This went away when I disabled the firewall on the LAN connection. Could you check if you've the same thing?
    # October 31, 2005 5:16 AM

    Erik Porter said:

    Frans, I wish it were that easy. I tried disabling my firewall and rebooting, but it still took just as long. :(

    Also, Raj, I used the SQL Server Surface Area Configuration tool to tell most of the services like analysis and reporting to not startup automatically and it seems to have sped up the initial load a bit, but it still takes about 35 seconds extra. Although it seems the mem usage is down a bit.

    It's all livable. It would just be nice to get it up faster.
    # October 31, 2005 10:42 AM

    Konstantin said:

    I have the same issue - it takes 140mb of memory... it's a little bit to much, I think..
    # November 1, 2005 7:17 AM

    Jason Mauss said:

    Hey Erik - I experienced some similar issues - and used the SAC tool like you mentioned. Have you discovered anything since that's helped reduce mem usage or startup time?
    # November 1, 2005 7:10 PM

    Erik Porter said:

    Not really, Jason. It's like running a full blown server. :-| The mem usage and starup time are what I'd expect SQL Server on a production machine to act like. Really weird. I've probably got too much configured or something. :-\
    # November 1, 2005 7:13 PM

    Alex Shyba said:

    Same things, guys. The process is constantly eating 450-500K or memory just after machine is started.

    # August 22, 2007 5:00 PM