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?
Processor : % Processor Time
Processor : % Privileged Time
Process(sqlservr) : % Processor Time
Process(sqlmangr) : % Processor Time
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.