Microsoft
70-450 · Question #59
70-450 Question #59: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #59. The question stem and answer options stay visible for context.
Question
You are a professional level SQL Sever 2008 Database Administrator. An instance runs on a computer, and the computer has eight quad-core processors and 128-GB RAM. The instance is utilized by four different applications. Not only a low number of CXPACKET waits but also a large number of lazy writer waits are experienced by the instance. The performance of the instance should be optimized. Which action will you perform to accomplish the goal?
Options
- ATo accomplish the goal, software non-uniform memory access (soft-NUMA) should be
- BTo accomplish the goal, the Resource Governor should be configured.
- CTo accomplish the goal, the Windows System Resource Manager should be configured.
- DTo accomplish the goal, an increase should be configured in the maximum degree of
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.