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
You administer a Microsoft SQL Server 2012 Enterprise Edition server that uses 64 cores. You discover performance issues
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
You administer a Microsoft SQL Server 2012 Enterprise Edition server that uses 64 cores. You discover performance issues
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!