Hello All ... I am looking for some advice on CPU affinity settings in SqlServer 2008. I have a 2 node 3 instance cluster with 16 cpu's and 104 GB's of ram. The OS is 2008 Enterprise.
The current setup is:
Instance 1
Processor: 0-7
IO : 8-15
Instance 2
Processor: 8-15
IO : 0-7
Instance 3
Processor: 0-3,8-11
IO : 4-7,12-15
Currently Instance 1 and Instance 3 are sharing a cluster node. I do see some spikes in CPU activity but those are generally focused during maintenance tasks, so that can be expected. Does anyone know of any best practices or any other recommendations?