Affinity In Sql Server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Affinity In Sql Server

We have been doing some testing to see if a particular app needs 4-way or 2-way cpu.
We got a 4-way machine with HT but we only set 2 cpu’s with HT to be used by sql server.
should i be unchecking use all available processesors and check the other one. thx

What sql and licency do you have? Luis Martin
Moderator One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
We have for 4-way but we just want to test for two-way. Thanks,

[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />] WHY????? Just curious?? If you have processor licensing, with SQL Server you have to pay for ALL physical processors on the server even if you’re not using them. So, you might as well use them all.<br /><br />MeanOldDBA<br />[email protected]<br /><br />When life gives you a lemon, fire the DBA.