You administer a Microsoft SQL Server 2012 Enterprise Edition server that uses 64 cores.
You discover performance issues when complex calculations are performed on large amounts of
data under heavy system load.
You need to limit the number of cores that handle the processing.
What should you configure?
A.
Max worker threads
B.
Processor affinity
C.
I/O affinity
D.
Lightweight pooling
It is I/O affinity
https://msdn.microsoft.com/en-us/library/ms189629.aspx
It’s B, you need to limit cores not disk I/O
B
You can specify/Map a particular thread(s) to work on specific CPU(s) (since high end server machines will run on 16 or more CPU). that is known as Processor Affinity.
Whereas, The affinity I/O mask or I/O Affinity option binds SQL Server disk I/O to a specified subset of CPU(s)