Does anyone know how to extract the CPUs used for a give SQL Server instance?
The information required for the cpu_affinity_mask can be extracted from SQL Server thus:
SELECT * FROM sys.dm_os_nodes WHERE memory_id <> 64
I have looked at the affinity mask, which is meant to give this information as a decimal string. As far as I know, you then have to convert it to a decimal string and then each decimal value (from right to left) relates to a specific CPU:-
CPU Affinity Mask: 1099510579200 (Decimal) CPU Affinity Mask: 111111111111111111100000000000000000000 (Binary)
Therefore Processors used should be:
BUT if you bring up the server properties, and then look at the processor affinity, only 22 to 33 are flagged as having an affinity.
Any help from the SQL Server gurus out there would be much appreciated.