Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Mismatch on deadlocks displayed on alarms and deadlocks report
Description
A time difference is seen between the alarms and email notifications generated by the "DBSS - Deadlocks" rule and the data displayed on the
"Databases | Overview | SQL Activity | Deadlocks" dashboard and the "Deadlocks Report".
Cause
Management Server (FMS) and Agent Manager (FglAM) that hosts the DB SQL Server agent are on different time zones.
Resolution
Troubleshooting:
It is noticed that there is a consistent time difference between the deadlocks displayed on the deadlocks dashboard and the deadlock alarms fired by the "DBSS - Deadlocks" rule.
The issue is present only for some of the database agents.
Database agents are are on different FglAMs.
Resolution:
The following time zones should be verified: FMS console/browser screen, FMS server time, DB host time, DB Agent FglAM host time.
Time zone should match to prevent time difference between alarms/notifications and dashboards/reports.
Additional Information
Issue was seen for the Deadlocks Reports / Dashboard Metrics and the Deadlocks Alarms / Email Notification, but it may be seen on different metrics
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
Search All Articles
IE 8, 9, & 10 No longer supported
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.
