Exam 70-462 topic 2 question 141 discussion

Actual exam question from Microsoft's 70-462

Question #: 141
Topic #: 2

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 process the calculations.
What should you configure?

A. Max worker threads
B. Processor affinity
C. I/O affinity
D. Lightweight pooling

Show Suggested Answer

Suggested Answer: B 🗳️
To carry out multitasking, the 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 data. 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:
https://msdn.microsoft.com/en-us/library/ms189629%28v=sql.110%29.aspx

by [deleted] at April 4, 2025, 11:34 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!