You administer a Microsoft SQL Server 2012 Enterprise Edition server that uses 64 cores.
You discover performance issues when large amounts of data are written to tables under
heavy system load.
You need to limit the number of cores that handle I/O.
What should you configure?
A.
Processor affinity
B.
Lightweight pooling
C.
Max worker threads
D.
I/O affinity
Explanation:
http://msdn.microsoft.com/en-us/library/ms189629.aspx
Processor affinity is correct.
why?
I/O Affinity looks “more right”. It is one of the masks available when setting processor affinity and according to Microsoft:
The affinity I/O mask option binds SQL Server disk I/O to a specified subset of CPUs.
Processor Affinity:
https://msdn.microsoft.com/en-us/library/ms187104(v=sql.110).aspx
Affinity I/O Mask:
https://msdn.microsoft.com/en-us/library/ms189629(v=sql.110).aspx