# Redgate SQL Monitor

[<mark style="color:blue;">Redgate SQL Monitor</mark>](https://www.red-gate.com/) is a database monitoring software used to easily monitor cloud or on-premises SQL-based databases.

Route detailed alerts from Redgate SQL Monitor to the right users in Squadcast.

### Using Redgate SQL Monitor as an Alert Source

1. Navigate to **Services** -> **Service Overview** -> select or search for your Service. Expand the accordion -> In the Alert Sources section, click **Add**.

![](https://1574591692-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8TaWz01jmUJl58p4ZVel%2Fuploads%2Fgit-blob-4fbd74e7ca0b30173c47a1d58ed6a0804a0465aa%2FAlert_Sources.png?alt=media\&token=aaca6610-9d18-4dd4-9cf5-320042f326f1)

2\. Select **Redgate SQL Monitor.** Copy the displayed **Webhook URL** to [configure](#create-a-squadcast-webhook-alert-in-redgate-sql-monitor) it within **Redgate SQL Monitor**. Finish by clicking **Add Alert Source** -> **Done.**

![](https://1574591692-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8TaWz01jmUJl58p4ZVel%2Fuploads%2Fgit-blob-6493dd756d829766dd28b19b8c24b343a9fe2859%2FRedgate%20SQL%20Monitor.png?alt=media\&token=0a851af9-23eb-4ded-9d26-a2e9174ed709)

{% hint style="warning" %}
**Important:**

When an alert source turns Active, it’ll show up under Configured Alert Sources, you can either generate a test alert from the integration or wait for a real-time alert to be generated by the Alert Source. An Alert Source is active if there is a recorded incident via that Alert Source for the Service.
{% endhint %}

### Create a Squadcast Webhook Alert in Redgate SQL Monitor

**(1)** Login to your Redgate SQL Monitor dashboard. Head over to the **Configuration** tab. Then under **Alerts and Metrics**, select **Notification settings**

![](https://1574591692-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8TaWz01jmUJl58p4ZVel%2Fuploads%2Fgit-blob-55d6d537082470273549767698c01db879ab7ccd%2Fredgate_sql_monitor_2.png?alt=media\&token=38bd0f9e-0253-4274-af10-eb4c4dd25150)

**(2)** Scroll to the **Webhook notifications** section, and choose when a SQL Monitor should send messages to your Webhook

![](https://1574591692-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8TaWz01jmUJl58p4ZVel%2Fuploads%2Fgit-blob-d08b706dc22b47ba328cea70632130850c2b6617%2Fredgate_sql_monitor_3.png?alt=media\&token=e6b29b4b-0c8e-464e-a4c3-4a5818c1a329)

**(3)** You can choose to send the **Default message** itself by selecting the radio button. Paste the previously copied Squadcast Webhook URL in the placeholder for **URL**.

You can also click on **Preview and test** to test the alert. This will create a test incident in Squadcast.

![](https://1574591692-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8TaWz01jmUJl58p4ZVel%2Fuploads%2Fgit-blob-e703601f3b64043de905b0bbaf1c7cda181b6848%2Fredgate_sql_monitor_4.png?alt=media\&token=9d16ea36-890e-4b96-8db3-dba3238aad48)

That's it, you are good to go! Your Redgate SQL Monitor integration is now complete. Whenever Redgate SQL Monitor fires an alert with **Status : Raised** or **Escalated**, an incident will be created in Squadcast for it. Also, when an alert status has changed to **Ended** in Redgate SQL Monitor, the corresponding incident gets **auto-resolved** in Squadcast.

*Have any questions?* [*Ask the community*](https://community.squadcast.com/view/home)*.*