CAUSE 1:
Usability alarm is not enabled under Administration | Alarms
CAUSE 2:
The Usability collection is set to 300 seconds for offline.
CAUSE 3:
The OS user account is not set correctly.
CAUSE 4:
EmailAction is set on the actual rule named Usability Availability
CAUSE 5:
Cloned Rule of Usability rule
CAUSE 6:
Blackout is set to block the instance alarms
RESOLUTION 1:
RESOLUTION 2:
RESOLUTION 3:
Databases dashboard | select the instance | Settings | Connection Details | click on Set credentials | click on Operating System
| ensure the OS user account is part of the administration group on the OS | click on Set button | click on Test Connection button to ensure the OS user account is correct.
RESOLUTION 4:
Check the FMS log for any EmailAction set on the actual rule for Usability.
FMS example:
YYYY-MM-DD HH:MM:SS.SSS VERBOSE [Action-4-thread-40003] com.quest.nitro.service.email.EmailSenderService - Email "Critical alarm for MSSQL instance TESTINSTANCE on host TESTINSTANCE was generated: Delivery latency for agent "SERVER1\INSTANCE-Single-IPMTransaction_wi-REPORTING\MYINSTANCE" is 199.00 seconds." has been sent to dba@test.com
If yes, expand Administration | Rules & Notification | click on Old Manage rules | search for DBO - Usability Availability, this will bring up the rule which shows the Rule condition query for Fatal and Critical tab. We will check both to see if there was email action setup under the Action tab.
RESOLUTION 5:
Expand Administration | Rules & Notification | click on Old Manage rules | search for DBO - Usability Availability (rule name) |
if the user notices cloned rule of Usability, there will not be Cartridge version listed if the user opens up the cloned rule.
This falls under customization.
RESOLUTION 6:
Ensure there are no Blackout set for the instance or Agent. If yes, remove it from Database | Settings | Manage Alarms Blackouts or Manage Agent Blackout | Remove the blackout for that instance. As a test, drill down on the instance from the Database dashboard | click on Activity | Real Time | check the Availability to see if there is blackout alert.
RESOLUTION 7:
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center