January 11, 2011 at 8:12 am
I installed 2008 R2 with 24 processors, is there a way i can configure on SQL Server so that I can dedicate 2 processors ofr OS and the rest for SQL Server? If so how could i do that?
January 11, 2011 at 9:18 am
Yes you can. In the properties window in Management Studio for the server (right click on the server in Object Explorer, select Properties from the menu). Click on the "processors" tab. There you can modify the processors used by SQL Server and you can set the Affinity to a particular set of processors. This means that SQL Server will only use those processors.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 11, 2011 at 9:46 am
While you can do what Grant explains, I would ask why you wish to do this?
CEWII
January 11, 2011 at 11:28 am
As Grant and Elliott have mentioned, Processor Affinity should be use with Caution. Please let us know if there is any special reason to do so.
Thank You,
Best Regards,
SQLBuddy.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply