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
b should be the correct answer
b is correct .
I/O Affinity binds SQL Server disk I/O to a specified subset of CPU(s). Why do we believe Processor affinity is correct?
Scratch that! Got the wrong question!
Process affinity is in I/O affinity. It means that I/O affinity is the correct answer
Oops yes B is correct
B is correct.
Processor affinity.
B.
Processor affinity
For answer I/O affinity, question will have specific keyword “i/o”.