You are a professional level SQL Sever 2008 Database Administrator. It is on a
four-processor, quadcore server. CPU pressure is regularly experienced by the server. An
extremely large mission-critical database is consisted by the instance, and it is utilized
constantly. The online index rebuilds should not occupy all available CPU cycles. From the
following four configurations, which one should you utilize?
A.
You should utilize affinity mask.
B.
You should utilize max degree of parallelism.
C.
You should utilize affinity I/O mask.
D.
You should utilize optimize for ad hoc workloads.