Run System Monitor
System Monitor uses remote procedure calls (RPCs) to collect information from Microsoft SQL Server. Any user who has Microsoft Windows permissions to run System Monitor can use System Monitor to monitor SQL Server.
When using System Monitor or Performance Monitor, you cannot connect to an instance of SQL Server that is running on Windows 98.
As with all performance monitoring tools, expect some performance overhead when you use System Monitor to monitor SQL Server. The actual overhead in any specific instance depends on the hardware platform, the number of counters, and the selected update interval. However, the integration of System Monitor with SQL Server is designed to minimize any reduction in performance.
If you have selected SQL Server performance counters to monitor in the System Monitor snap-in, you will see the counters even if SQL Server is not running.
For information about starting System Monitor, see Start System Monitor (Windows).