11 November 2016
11 November 2016

Integrating SQL Monitor alerts with other systems

One of SQL Monitor’s most valuable capabilities is raising alerts when bad things happen in SQL Server. The alerts are listed within SQL Monitor but can also be sent out as emails. However, many of our customers have said they’d like to see those alerts in their other systems too. The latest version of SQL Monitor does just that, allowing you to send reports either as SNMP traps, or as messages into Slack.

Slack

Slack has become an essential communications tool for people working in teams (we use it at Redgate), so it was a no-brainer to integrate SQL Monitor alerts into Slack.  Setup is simple.  Go to the configuration tab in SQL Monitor and click on Notification Settings. It’s then just a question of filling in a webhook url (obtained from Slack), along with a username and the channel to post to.

SQL Monitor notification configuration screenshot

You’ll receive messages like these, giving an overview of the alert, along with a link to view its details in SQL Monitor.

SQL Monitor Slack messages

Everybody in your team’s Slack channel can then see the alerts as they come through.

SNMP Traps

Likewise, SNMP traps are configured in a similar way and don’t require much setup – just a target IP address and a community string. You can consume SNMP traps in other tools like SCOM or ServiceNow, enabling you to treat SQL Monitor’s detailed alerts as part of the incident escalation processes you have created in those services.

SQL Monitor SNMP trap

One point to note is that currently if you disable an e-mail notification for a particular alert, you will not get a Slack or SNMP trap message either.

We’d really appreciate any feedback on this. Let us know how you’re using it, or if you encounter any problems – just email SQLMonitorFeedback@red-gate.com.

If you’d like to know more about how to configure SCOM 2012R2 to consume alerts from SQL Monitor, I’ve written another blog post where I give a walkthrough.

Tools in this post

SQL Monitor

SQL Monitor is a SQL server monitoring tool that transforms the way you look at your database. It cuts your daily check to minutes, with a web-based overview of all your SQL Servers.

Find out more

Share this post.

Share on FacebookShare on Google+Share on LinkedInTweet about this on Twitter

You may also like

  • Article

    Monitoring Changes in Permissions, Users, Roles and Logins

    Compliance means keeping a close grip on any changes to the permissions and access control of a database. Sadly, the law has had to acknowledge, from bitter experience, that it is not just external intruders who want to do this, but it could also be attempts at fraud or data theft from within the organisation.

  • Article

    Why is my query suddenly slow?

    Sometimes query performance problems sneak into SQL Server after a software release that involves database schema or code changes, and you must hunt down the offending query and tune it. Other times, however, the performance changes for less immediately explicable reasons. I’m sure we’ve all experienced this situation: your system is humming along, and you’ve

  • Article

    Monitoring the Application with SQL Monitor: Website Activity

    As well as being essential for giving you an overview of the SQL Server installations that you look after, SQL Monitor can also be used in ways that aren’t so immediately obvious. One immediate advantage it has as a monitoring tool is that it isn’t part of any one server, database or application: it is

  • Webinar

    The three biggest challenges of SQL Server monitoring

    In this webinar Microsoft MVP Grant Fritchey and Redgate's James King will exclusively reveal the three biggest challenges SQL Server professionals face when monitoring their estates. Grant and James will go through the top three challenges reported by respondents to our 2018 State of SQL Server Monitoring industry survey, look into the details of the problems faced, and discuss what solutions you could implement to overcome them.

  • University

    Take the SQL Monitor course

    This course takes you from installation and configuration, all the way up to getting the most out of the advanced features in SQL Monitor to help you proactively monitor your SQL Server estate. Learn how to explore in-depth issues in your environment, run an analysis, manage alerts, create custom metrics, and more.

  • Forums

    SQL Monitor Forum

    Real-time SQL Server performance monitoring, with alerts and diagnostics