About SQL Monitor
Published 05 December 2012
SQL Monitor is a web-based monitoring and alerting tool for SQL Servers. It displays real-time data about the current performance of all host machines, SQL Server instances, and databases that you choose to monitor, and raises alerts when problems occur. Use SQL Monitor to:
- Identify servers that require attention using the Global Overview
- Drill down to view the current health and performance of any server or database
- View detailed alerts for a wide range of issues such as job failures, deadlocks, overdue backups and fragmented indexes
- Configure each type of alert for each server, job, database etc., to suit your environment; and set up email notifications
- Analyze performance metrics over time to determine performance trends and identify abnormal performance
- Create custom metrics and alerts to collect the metric data you're most interested in, and alert you to changes specific to your environment
- Automatically install custom metrics and alerts from Red Gate's online resource for SQL Monitor metrics
- "Rewind time" to review the activity on your servers when a problem occurred in the past
- Run your own reports against the Data Repository SQL Server database that contains monitored data
What's new in version 3.5
Version 3.5 includes support for baselining metrics. See Using a baseline for comparison.
We've also fixed a number of bugs. For more details, see SQL Monitor 3.5 release notes.
Worked examples
To learn about using SQL Monitor, see: