Microsoft
70-450 · Question #44
70-450 Question #44: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #44. The question stem and answer options stay visible for context.
Question
You administer a SQL Server 2008 infrastructure. An instance runs on a computer that has eight quad-core processors and 128-GB RAM. Four different applications use the instance. The instance experiences a low number of CXPACKET waits. The instance also experiences a large number of lazy writer waits. You need to optimize the performance of the instance. What should you do?
Options
- AConfigure the Resource Governor.
- BConfigure the Windows System Resource Manager.
- CConfigure software non-uniform memory access (soft-NUMA).
- DConfigure an increase in the maximum degree of parallelism option.
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.