June 6, 2012 at 8:19 pm
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:
https://support.quest.com/Search/SolutionDetail.aspx?ID=SOL76183
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?
June 6, 2012 at 8:19 pm
It seems the last error for this in Foglight has now continued for 16 hours. Having looked at my actual database mirror on many occasions, I can 100% confirm the mirror is working perfectly...
- No SQL or server errors
- No Foglight Client errors
-100% mirroring sync with <1ms wait time
- the database Status is "Restoring" as per normal.
The Foglight client application itself is able to monitor all other rules successfully.
I am at a loss. Anyone have any ideas? Does anyone know exactly how the "db_status" data in Foglight is extracted from SQL server?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply