SQL CoPilot sits by your side. It is there ready for action whenever you have an issue to investigate. Maybe you give it a second screen, or dock it on your main screen.
So why not give another task? SQL Server monitoring. Let SQL CoPilot silently keep an eye on all your instances and let you know if it finds a problem. This was the most common request we received and so we have now added SQL Server monitoring to SQL CoPilot!
SQL CoPilot already uses tags to group similar instances for quick access and management, so the same tags are now used to group instances to be monitored.
Assign the following alerts to one or more tags, specify thresholds and whether an alert is critical or just a warning. And that's it. SQL CoPilot checks the servers in the background and displays the alerts in a dashboard or list with popup messages and red/orange toolbar badges making sure you don't miss anything.
Alerts currently raised are:
All thresholds used are fully configurable.
Here we see that production, DR and dev/test instances are being monitored
Here we see that production and DR servers have been given 2 thresholds, at critical and warning levels, whilst dev/test servers only raise a warning. This is all fully configurable.
Here is a dashboard showing all monitored instances, color-coded according to issue severity. Note also the popup message showing the alert that has just been raised, and the badge next to the Monitoring On/Off button. Clicking the badge shows the alert list in the next screenshot.
This is the list you see when you click on a badge
Clicking on any row in the alert list opens a connection to the instance and shows you the issue in more detail. Here we have clicked on the "Offline database" alert
Nothing! SQL CoPilot is licensed for a small per-user amount and SQL Server monitoring is included at no extra cost.
Download it now and start monitoring your SQL Servers today.