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?
A
. Processor affinity
B. Lightweight pooling
C. Max worker threads
D. I/O affinity
Reference:
You must be logged in to post a comment.
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 must be logged in to post a comment.
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 un
der heavy system load.
You need to limit the number of cores that process the calculations.
What should you configure?
A. Max worker threads
B. Processor affinity
C. I/O affinity
D. Lightweight pooling
Explanation:
To carry out multitasking, t
he operating system sometimes moves process threads among different processors. This is efficient from an operating system point of view, but can reduce SQL Server performance under heavy system loads, as each processor cache is repeatedly reloaded with da
ta. Assigning processors to specific threads can improve performance under these conditions by eliminating processor reloads; such an association between a thread and a processor is called processor affinity.
References:
You must be logged in to post a comment.