试题详情
单项选择题 You administer a SQL Server 2008 infrastructure. An instance runs on a computer that has eight quad-core processors and 128-GB RAM. Four different applications use the instance. The instance experiences a low number of CXPACKET waits. The instance also experiences a large number of lazy writer waits. You need to optimize the performance of the instance. What should you do?()

A、Configure the Resource Governor. 

B、Configure the Windows System Resource Manager. 

C、Configure software non-uniform memory access (soft-NUMA).

D、Configure an increase in the maximum degree of parallelism option.

  • C
  • 关注下方微信公众号,在线模考后查看

热门试题