MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide

Review Questions

1. You are the database administrator for your company responsible for a SQL Server 2005 instance. You have noticed in Task Manager that the processor utilization is at 100 percent, so you need to investigate the cause. You decide to use System Monitor to determine whether the SQL Server instance is consuming the processor resources. What performance object counter should you monitor?
   1. Processor : % Processor Time
   2. Processor : % Privileged Time
   3. Process(sqlservr) : % Processor Time
   4. Process(sqlmangr) : % Processor Time
2. You are the database administrator for your company. You are responsible for designing a strategy to monitor a SQL Server 2005 instance. You need to implement a mechanism that will detect CREATE TABLE statements regardless ...