Microsoft
70-450 · Question #106
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…
The correct answer is C. max degree of parallelism. See the full explanation below for the reasoning.
Question
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?
Options
- Aaffinity mask
- Baffinity I/O mask
- Cmax degree of parallelism
- Doptimize for ad hoc workloads
How the community answered
(47 responses)- A9% (4)
- B4% (2)
- C70% (33)
- D17% (8)
Community Discussion
No community discussion yet for this question.