-
Titolo
How to edit alarms and change thresholds for the database monitored agents in cartridge versions below 6.0.0 -
Descrizione
How to edit alarms and change thresholds for the database monitored agents?
,
-
Causa
Step by Step Instructions on how to adjust the alarms thresholds for the Oracle, SQL Server, and DB2 Database monitored agents.
-
Risoluzione
This video is applicable for Foglight database cartridge versions below 6.0.0Users can customize how the alarms generated by the default Foglight for Databases rules are triggered and displayed in the Alarm view’s Settings tab. All changes to alarm settings apply to the selected agents, with the exception of thresholds, which can be customized by agent.
The Alarms list controls the contents displayed to the right and the tasks that are available.- All Alarms – Displays all rules with configured alarms and indicates whether alarms are enabled. In this view, users can enable or disable alarms for all the rules at once. Users can also set email notifications and define mail server settings.
- Category of rules – Displays a set of related rules with configured alarms. In this view, users can enable or disable alarms and also set email notifications for the category of rules.
- Rule name – Displays the alarm status for the selected rule. If the rule has multiple severity levels, displays the threshold configured for each severity level. In this view, users can enable or disable the alarm, edit the alarm text, and edit severity levels and their thresholds. Users can also set email notifications for the alarm.
Users can complete the following tasks:- Enabling or disabling alarms for selected agents
- Modifying alarm threshold values
- Editing the text of the alarm message
Changes are saved separately and applied over the default rules. This protects users from software upgrades that may change the underlying default rules.Enabling or disabling alarms for selected agents
Users can override the global alarm sensitivity level setting for the selected agents. Users can enable or disable alarms for all rules, a category of rules, or an individual rule.IMPORTANT: Avoid editing Foglight for Database rules in the Administration > Rules & Notifications > Rule Management dashboard. Default rules may be modified during regular software updates and edits will be lost. Always use the Alarms view.
To enable or disable alarms:
- In the Alarms view, click the Settings tab.
- Decide on the scope for the change: all alarms, a category of rules, or a selected rule.
- Complete the steps for the selected scope (below)
- Click Save changes
Scope Procedure All alarms Click All Alarms. In the Alarms Settings tab, click either Enable all or Disable all. Category of rules Click a category. Click either Enable all or Disable all. Selected rule Click the rule. In the Alarms Settings tab, click the link that displays the alarm status. Select Enabled or Disabled from the list and click Set. Modifying alarm threshold values
Users can and should modify the thresholds associated with alarms to better suit the environment. If users find that alarms are firing for conditions that are considered to be acceptable, users can change the threshold values that trigger the alarm. Users can also enable or disable severity levels to better suit the environment.When a rule has severity levels, a Threshold section appears in the Alarm Settings tab showing the severity levels and bounds by agent. Many rules, such as Baseline rules, do not have severity levels and thresholds.
When editing thresholds, ensure that the new values make sense in context with the other threshold values. For most metrics, threshold values are set so that Warning < Critical < Fatal. However, in metrics where normal performance has a higher value, such as DBO - SGA Library Cache, the threshold values are reversed: Warning > Critical > Fatal.
To change severity levels and thresholds:
- In the Alarms view, click the Settings tab.
- Click the multiple-severity rule to edit.
- Click the Alarms Settings tab.
- In the Threshold section, review the defined severity levels and existing threshold bounds for all target agents. The colored bar across the bottom of the view indicates the percentage of collections that fall within each threshold.
- From this view, users can perform the following tasks (see below)
- Click Save changes.
Task Procedure Edit severity levels and set threshold (lower bound) values for all agents. Click Enhance alarm. Select the check boxes for the severity levels you want enabled and set the threshold values. Click Set. Change the threshold (lower bound) values for one agent. Click Edit beside the agent name. Set the new threshold values and click Set. Copy the changes made to one agent’s threshold values to all other agents. Click Edit beside the agent name that has the values you want to copy. Select Set for all agents in table and click Set. TIP: To review the thresholds for all Foglight for Database rules in a single view, use the Rule Management dashboard. In the navigation panel, click Homes > Administration, then click Rules. Type DBO, DBSS, or DB2 in the Search field to see the list of predefined rules for Oracle, SQL Server, or DB2 databases (respectively). For rules with severity levels, users can see the threshold values set for each level. To edit threshold values, return to the Alarms view. Edits made directly to the default rules may be overwritten during software upgrades.Editing the text of the alarm message
For individual rules, users can change the message displayed when an alarm fires. Users cannot add or remove the variables used in the message. This is a global setting that affects all agents.
To change the alarm message:
- In the Alarms view, click the Settings tab.
- Select a rule.
- Click the Alarm Settings tab.
- Click Enhance alarm.
A Customize dialog box opens. - In the Message box, edit the message text.
If desired, users can restore the default message by clicking Reset message. - Click Set
- Click Save changes.
-
Allegati