SQL Monitor alerting for Missing Disks

Luke L

Today we removed a disk from one of our FCI's. I expected Sqlmonitor to alert that the disk went missing. Is this something that we need to configure differently, or is that functionality not part of SQL monitor. FWIW, our Network group's monitoring software caught it and alerted.

Thanks,
-Luke.

RichardL

Hi @Luke L

Thanks for your post.

SQL Monitor will only alert on disk space and not on availability as highlighted in the link below.

https://documentation.red-gate.com/sm7/alerts/list-of-alerts

You can always make suggestions for future features on our SQL Monitor Uservoice page in the other link below.

https://sqlmonitor.uservoice.com/forums/91743-suggestions

Kind regards

Richard Lynch.

Luke L

Richard, thanks for the quick response. I assumed this wasn't built into SQL monitor yet, but wanted to make certain as I couldn't easily figure out how setup an alert to handle it. We'll likely code some sort of custom alert for this with an instance local config table and xp_FixedDrives. It's not optimal because of the reliance on undocumented system procedures but...

It seemed like SQL monitor should be able to perform this check since it was already interrogating the servers and storing the disk information. A check against what disks it saw in the last check seems like it would be fairly quick/easy to implement.

BTW, your competitors already have this alert.

The suggestion is https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/33580537-monitor-for-unavailable-disks for anyone who wants to upvote it.

Thanks,
-Luke L.