单项选择题
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?（）
A.Configure the Resource Governor.
B.Configure the Windows System Resource Manager.
C.Configure software non-uniform memory access (soft-NUMA).
D.Configure an increase in the maximum degree of parallelism option.
相关考题
-
单项选择题
You administer a SQL Server 2008 instance. The instance is located on a four-processor, quad-core server. The server frequently experiences CPU pressure. The instance contains a very large mission-critical database that is used continuously. You need to ensure that online index rebuilds do not consume all available CPU cycles. Which configuration option should you use?（）
A.affinity mask
B.affinity I/O mask
C.max degree of parallelism
D.optimize for ad hoc workloads -
单项选择题
You administer a SQL Server 2008 instance. You plan to deploy a new database that has the following capacity requirements: 275 GB for the database data file; 50 GB for the transaction log file. The storage array has six 100-GB disk drives available for the database. The disks are attached to a redundant array of independent disks (RAID) controller that supports RAID levels 0, 1, 5, and 10. The write performance of the transaction log needs to be maximized. The database and transaction log files must be protected in the event of a drive failure. You need to design the storage system. Which storage configuration should you use?（）
A.A single RAID 5 volume
B.A single RAID 10 volume
C.A RAID 0 volume and a RAID 5 volume
D.A RAID 1 volume and a RAID 5 volume
