What should you configure?

You administer a Microsoft SQL Server 2016 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

Answer: D

Explanation:

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

Latest 70-764 Dumps Valid Version with 451 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments