O'Reilly logo

MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide by Andy Warren, J. Steven Jones, Marilyn Miller-White, Victor Isakov

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required