试题详情
- 单项选择题 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
关注下方微信公众号，在线模考后查看
热门试题
- Your company has an
- Your organization h
- You need
- Your network&e
- Your network&e
- Your company&e
- You have
- Your network&e
- Your company&e
- Your company has an
- You manage&ens
- Rate your level of p
- You have
- Your company has a m
- You have
- Your network&e
- Your company has an
- You need
- Your company has two
- Your company runs Wi