Monitoring Resource Usage (System Monitor)

Other versions are also available for the following:

SQL Server 2005

SQL Server 2008 Books Online

Monitoring Resource Usage (System Monitor)

If you are running Microsoft Windows server operating system, use the System Monitor graphical tool to measure the performance of SQL Server. You can view SQL Server objects, performance counters, and the behavior of other objects, such as processors, memory, cache, threads, and processes. Each of these objects has an associated set of counters that measure device usage, queue lengths, delays, and other indicators of throughput and internal congestion.

Note:
System Monitor replaced Performance Monitor after Windows NT 4.0.

In This Section

Topic	Description
System Monitor Scenarios	Contains information about what system events you can monitor.
Monitoring Disk Usage	Contains information about the physical disk counters you can use to monitor disk I/O, paging, and disk activity created by SQL Server.
Monitoring CPU Usage	Contains information about the system and processor counters you can use to monitor SQL Server CPU usage.
Monitoring Memory Usage	Contains information about the memory counters you can use to isolate SQL Server memory usage.
Creating a SQL Server Database Alert	Contains information about how to create a database alert that is raised when a threshold value for a System Monitor counter has been reached.
Running System Monitor	Contains information about considerations for running System Monitor and about how to start it.
Creating Charts, Alerts, Logs, and Reports	Contains information about the charts, alerts, logs, and reports that you can create by using System Monitor.
Using SQL Server Objects	Contains information about SQL Server performance objects.

Product Families

Resources

About Microsoft

Popular Places

Popular Searches

Popular Downloads