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.
System Monitor replaced Performance Monitor after Windows NT 4.0.
Contains information about what system events you can monitor.
Contains information about the physical disk counters you can use to monitor disk I/O, paging, and disk activity created by SQL Server.
Contains information about the system and processor counters you can use to monitor SQL Server CPU usage.
Contains information about the memory counters you can use to isolate SQL Server memory usage.
Contains information about how to create a database alert that is raised when a threshold value for a System Monitor counter has been reached.
Contains information about considerations for running System Monitor and about how to start it.
Contains information about the charts, alerts, logs, and reports that you can create by using System Monitor.
Contains information about SQL Server performance objects.