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.