Skip to main content

Integrations

Redgate SQL Monitor Integration Guide

Redgate SQL Monitor is a SQL Server monitoring and alerting tool, designed to allow Ops teams to supervise many SQL Server instances across different networks, hosted on "bare metal" servers, in Virtual Machines, or in the cloud.

What can Zenduty do for Redgate SQL Monitor users?

With Redgate SQL Monitor's Integration, Zenduty sends new alerts to the right team and notifies them based on on-call schedules via email, text messages(SMS), phone calls(Voice), Slack, Microsoft Teams and iOS & Android push notifications, and escalates alerts until the alert is acknowledged or closed. Zenduty provides your NOC, SRE and application engineers with detailed context around the Network Monitor alert along with playbooks and a complete incident command framework to triage, remediate and resolve incidents with speed.

You can also use Alert Rules to custom route specific Redgate SQL Monitor alerts to specific users, teams or escalation policies, write suppression rules, auto add notes, responders and incident tasks.

To integrate Redgate SQL Monitor with Zenduty, complete the following steps:

In Zenduty:

  1. Go to Teams and click on the team you want to add the integration to.

  2. Next, go to Services and click on the relevant Service.

  3. Go to Integrations and then Add New Integration. Give it a name and select the application Redgate SQL Monitor from the dropdown menu.

  4. Go to Configure under your Integrations and copy the generated Webhook URL.

In Redgate SQL Monitor:

  1. Login to your Redgate SQL Monitor. Go to Configuration > Alerts and Metrics > Notification settings.

  2. Choose when SQL Monitor should send messages to Webhook.

  3. Choose to send either the default message or define a custom message to send.

    Note: We recommend to choose default message. For any specific requirements if you are choosing custom message then make sure below fields are present in Payload. You can add other fields as per your requirments. Below fields are required to create an Incident at Zenduty.

    {
    "statusChange" : "{{alert-status}}",
    "severity" : "{{alert-severity}}",
    "id" : "{{alert-id}}",
    "baseMonitorGuid" : "{{base-monitor-guid}}",
    "messageType" : "AlertNotification"
}

  4. Enter the Webhook URL which you copied from Zenduty into the URL box.

  5. Click Send Test Notification to check alerts are getting created at Zenduty.

  6. Redgate SQL Monitor is now integrated with Zenduty. Zenduty will create an incident for each Raised events and it will auto resolve the incident on receiving Ended event alert.

Zenduty SignUp