Red Gate SQL Monitor is a world-class performance monitoring tool for Microsoft SQL Server databases. SQL Monitor provides comprehensive machine, cluster, server and database health checks and performance dashboards. It also offers a rich reporting and fault analysis engine to help you quickly diagnose the root cause of db operational issues.SQL Monitor can be easily configured to send alerts to PagerDuty (via email), thus allowing you to take advantage of PagerDuty’s comprehensive alerting and incident tracking functionality.
You can set up PagerDuty to alert your database admins and sysadmins via phone call and SMS, as well as email of course. You’ll also be able to configure automatic escalation of alerts, handle alerts on-the-go from a mobile phone, and set up on-call duty scheduling.
You’ll need an installation of SQL Monitor. For best results, we recommend using version 2.3 or any later version. Older versions of SQL Monitor will also work, but you will miss out on automatic resolution of incidents in PagerDuty when the underlying db problems have been fixed. You’ll also miss out on the ability to configure alert filters based on the severity of the SQL Monitor alert. If you don’t have SQL Monitor, you can get the latest version here.You will also need a PagerDuty account; either a paid account or free trial will work.