试题详情
单项选择题 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
  • 关注下方微信公众号,在线模考后查看

热门试题