SQL Server Performance Forum – Threads Archive
Affinity In Sql ServerHello,
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
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
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.