I've just found this query :
select scheduler_id,cpu_id, status, is_online from sys.dm_os_schedulers where status='VISIBLE ONLINE'
Which seems to list the processors that SQL is using.
When I configured the testing instance with the Processor Affinity checked for CPU0-5, and I/O Affinity checked on CPU6-11 I get the following:
12 0 VISIBLE ONLINE 1
13 1 VISIBLE ONLINE 1
14 2 VISIBLE ONLINE 1
15 3 VISIBLE ONLINE 1
16 4 VISIBLE ONLINE 1
17 5 VISIBLE ONLINE 1
So, does this mean that I need to reconfigure with CPU6-11 being under the Processor Affinity option, and remove all from the I/O affinity? I'm just making myself more confused :)
Hi, this NUMA link may help make it clearer http://msdn.microsoft.com/en-us/library/ms345345.aspx and it also has some how to links.