性能优化的基本原则是 A: 不要过早做不成熟的优化 B: 不要优化 C: 性能分析工具是无用的 D: 不需要关注系统的workloads

A batch application executes a large number of update statements. The service level agreement for the application states that the application must complete its work as quickly as possible to ensure that dependent workloads can start ontime. What is one way to help the application complete quickly?（） A: Code the application to issue a LOCK TABLE statement.   B: Code the application to issue a LOCK ROW statement.   C: Decrease the number of I/O servers.   D: Increase the locklist parameter.

A batch application executes a large number of update statements. The service level agreement for the application states that the application must complete its work as quickly as possible to ensure that dependent workloads can start ontime. What is one way to help the application complete quickly?（） A: Code the application to issue a LOCK TABLE statement. B: Code the application to issue a LOCK ROW statement. C: Decrease the number of I/O servers. D: Increase the locklist parameter.&e

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