You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 infrastructure is managed by you.
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?
A.
To accomplish the goal, software non-uniform memory access (soft-NUMA) should be configured.
B.
To accomplish the goal, the Resource Governor should be configured.
C.
To accomplish the goal, the Windows System Resource Manager should be configured.
D.
To accomplish the goal, an increase should be configured in the maximum degree of parallelism option.