Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Run System Monitor

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Note Note

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.

Note Note

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).

Community Additions

ADD
Show:
© 2015 Microsoft