December 12, 2010 at 6:48 am
Hi...
I have been a SQL Server developer for years but just installed SQL Server 2008 (not r2) 64-bit on my personal Win7-64 Pro dual-core laptop. I did this to play around with it and learn more things about managing SQL Server...
One thing I wasn't prepared for was how much my laptop slowed down during Windows startup after installing SQL Server. Since I'm not using SQL Server for much of anything, I was wondering if I could give it less resources or a lower priority when starting up so I could use my laptop in other ways...
I have been searching online and can't find any option to start SQL Server services with lower priority, as I have no need for regular or high. I recognize that it can be changed after-the-fact (e.g. a command that runs from the Startup folder), but that defeats the purpose as Explorer & SQL Server are already up & running. The only other possibility that I found was to remove processor and disk I/O affinity from one of the cores--e.g. force it to use CPU1 all the time. Is there anything else I missed or could look into?
As I said before, my interest is in improving Windows startup time at the expense of SQL Server. I recognize that this is the opposite of what most people would do. Thanks...
December 12, 2010 at 7:15 am
You could always set the service to start manually and only start it when you need it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply