Is anyone else getting false-positives on the "DBSS - Unavailable" rule for mirrored databases?
Once every week or two I am getting a fatal alert of "Unavailable" for the "DBSS - Unavailable" rule on all of the mirrored databases for my server. It only lasts for a few minutes in Foglight then goes back to a normal status.
I have looked at all Database Monitoring logs for both the Mirror and Principle, all SQL server and Agent logs, all server event logs.. nothing. The entire history of all mirrored databases have no sign of availability issues according to the actual SQL server itself.
The only reference towards this Foglight Rule is:
Going by the article, I have looked at the data stored in "DB Status" for the affected databases, which it states "Unavailable" for the times the alert has come up. However, I cannot locate anywhere on the actual SQL server where this error might have come from.
I don't particualrly want to go rushing towards false-positive fatal alerts stating my mirror is unavailable
Any thoughts on what else I could try? Has anyone experienced this issue?
Or is this just a blip?