Hi, I have a client who we just upgraded to Win 2008 R2 Standard Edition and SQL 2008 R2 Standard Edition
They are complaining about System performance.
Looks like SQl runs only on 1 core, maybe sometime 2 which is maxed out.
"Automatically set Processors affinity mask for all processors" is checked and also
"Automatically set I/O affinity mask for all processors" is checked...
The server was maxed out with memory a few days ago but looks to me that that is something taht SQL 2k8 R2 does. The server has got 16GB ram
Pretty urgent. Got 3 hours to solve it.
View Complete Post