You administer a Microsoft SQL Server 2016 Enterprise Ed
ition 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. Lightw
eight pooling
C. Max worker threads
D. I/O affinity
References: http://msdn.microsoft.com/en-us/library/ms189629.aspx