We are using Foglight to monitor some SQL Server "Mirrored" servers. We need Foglight to call errors when the Mirror State changes.
There is an error in Foglight called "DBSS - Database Mirroring State Changed."
We are finding that this error is not being called consistently when the mirror state changes.
Actually, this error has been called a couple of times but most of the time it doesn't work.
Foglight is not exactly a realtime monitor but collects at a certain rate. If the issue does not exist when the collection happens, it will not know the event occured or that it should alert on that scenario.
The collection is every 15 minutes if the console is not open or 5 minutes if someone has the console open.
If the state chages more then once during the collection, it will still only send one alert and this is by design.
