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 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.
You’ll receive messages like these, giving an overview of the alert, along with a link to view its details in SQL Monitor.
Everybody in your team’s Slack channel can then see the alerts as they come through.
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.
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.
Also in Hub
Using TOP in a SELECT statement without a subsequent ORDER BY clause is legal in SQL Server, but meaningless because asking for the TOP 10 rows implies that the data is guaranteed to be in a certain o...
Also in Product learning
People can, and do, argue a great deal about the relative merits of table variables and temporary tables. Sometimes, as when writing functions, you have no choice; but when you do you’ll find that b...
Also in SQL Monitor
Many organizations are experiencing rapid expansion and diversification of their SQL Server estate to include Cloud, VMWare and other platforms, alongside traditional on-premise servers. This article ...
Also about SQL Monitor
Today Microsoft released the public preview of Azure SQL Database Managed Instances – an exciting new option for running SQL Server workloads in the cloud. I'm pleased to say that initial support fo...