Monitoring SQL Server Performance

Reliability And Performance Monitor is the tool of choice for monitoring SQL Server performance. Reliability And Performance Monitor graphically displays statistics for the set of performance parameters you select. These performance parameters are referred to as counters.

When you install SQL Server on a system, Reliability And Performance Monitor is updated with a set of counters for tracking SQL Server performance parameters. These counters also can be updated when you install services and add-ons for SQL Server. For example, when you configure replication on a server, Replication Monitor is added and made available through SQL Server Management Studio, and Reliability And Performance Monitor is again updated ...

Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.