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?
A.
To accomplish the goal, an increase should be configured in the maximum degree of
parallelism option.
B.
To accomplish the goal, the Windows System Resource Manager should be configured.
C.
To accomplish the goal, software non-uniform memory access (soft-NUMA) should be
configured.
D.
To accomplish the goal, the Resource Governor should be configured.