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 specific to your environment
• "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 all collected data

Quick start guide

To start using SQL Monitor, you need to:

1. Check prerequisites and access permissions. See Requirements.
2. Install SQL Monitor components - Base Monitor, Web Server and Data Repository. See Installing.
3. Create an Administrator password. See Creating the Administrator role.
4. Choose the servers you want to monitor. See Adding servers to monitor.
5. Activate server licenses. See Licensing.
6. Configure email settings for alerts. See Setting up email notification.

Worked examples

To learn about using SQL Monitor, see: 

• Example configuration using virtualization software