Showing posts with label athlon. Show all posts
Showing posts with label athlon. Show all posts

Wednesday, March 21, 2012

Processor affinity?

Hi there. This might be a dumb question, so please excuse me if it is :-) I recently purchased an AMD Athlon x2 machine. I'm running SQL Server 2005 (this is a development machine).

I'm rapidly learning that the second processor in this machine is pretty much completely unused. Is there a way in setup or in a config file or something for SQL Server 2005 to tell it to use the second processor?

Thanks in advance...

-Eric HarmonThis is for SQL 2000, but anyway: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_config_5lfd.asp

Make sure you're not running SQL 2005 Express, it only supports one processor...