Administering a SQL Database Infrastructure — Question 131

You administer a Microsoft SQL Server 2016 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?

Answer options

• A. Processor affinity
• B. Lightweight pooling
• C. Max worker threads
• D. I/O affinity

Correct answer: D

Explanation

Configuring I/O affinity directly addresses the issue of limiting the number of cores that handle I/O operations, thereby improving performance during heavy data writes. The other options, such as processor affinity and max worker threads, do not specifically target I/O management, making them less effective for this scenario.