SQL Server Performance Forum – Threads Archive
Affinity In Sql Server
Hello,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
SQL-Server-Performance.com 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=’
![Smile :) :)](styles/default/xenforo/smilies/smile.png)
]]>