What should you configure?

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?

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

Explanation:
http://msdn.microsoft.com/en-us/library/ms189629.aspx



Leave a Reply 1

Your email address will not be published. Required fields are marked *