单项选择题
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
