Microsoft
70-457 · Question #125
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…
The correct answer is D. I/O affinity. See the full explanation below for the reasoning.
Question
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?
Options
- AProcessor affinity
- BLightweight pooling
- CMax worker threads
- DI/O affinity
How the community answered
(28 responses)- A4% (1)
- B7% (2)
- C11% (3)
- D79% (22)
Community Discussion
No community discussion yet for this question.