How to Integrate Red Gate SQL Monitor with PagerDuty

Introduction

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.

What you’ll need to get started

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.

Setting up the PagerDuty / SQL Monitor integration

In PagerDuty:

  1. Click on the Services tab.
  2. On the right sidebar, click the Add New Service button.
    SL-AddNewServiceButton
  3. Enter a name for the service and select an escalation policy.
  4. Start typing “SQL Monitor” under “Integration Type” to filter your choices.
    SQLMonitor
  5. Click the Add Service button.
  6. You’ll be taken to the service page. Copy the Integration email to the clipboard; you’ll need it to set up the integration in SQL Monitor.
  7. (Optional) By default, your new service only opens new incidents for Medium or High severity alerts received from SQL Monitor. To modify this setting, from the service page, click on the Edit this service link on the right sidebar. You’ll then be able to configure the service to open incidents only for High severity alerts, only for High and Medium severity alerts, or for any alert.

In SQL Monitor

  1. Click on the Configuration tab.
  2. Under the Alerts section, click on Email settings.
  3. Under the field labelled Send emails to, Paste the service integration email that you copied to the clipboard in step 5 above. Also be sure to set a from email address for the alert emails (something like sql-monitor@your-company.com).