Submit My Question - Recent Questions - Recent Answer

Msdn Tech >> SQL Server >> SQL Server Setup & Upgrade

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 Harmon

[437 byte] By [EricHarmon] at [2007-12-17]

«« Brushes? How do I pass a "Brushes" as a parameter?
»» Print control code

# 1

This 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...

DanielRieck at 2007-9-8 >

top of Msdn Tech,SQL Server,SQL Server Setup & Upgrade...

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified