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
正确答案:C
答案解析:有
微信扫一扫手机做题