Configuration Rules for database monitoring 

Configuration Rules enable you to associate predefined actions for different monitor groups to track configuration changes and maintain optimal settings. These rules allow for specific criteria to be established, which determines the actions that will be applied to the monitors.

Set up Configuration Rules 

1. Log in to Site24x7 and go to Admin > Inventory > Configuration Rules. Click Add Rule.

2. Provide a Display Name and Description for the rule.

3. Define Criteria: Define the criteria as AND or OR. Based on the criteria defined (AND or OR), either one criterion (OR) or all of them (AND) will be taken into consideration for executing an action.

4. Select your preferred database as the Monitor Type.

5. Click the plus icon + to include the monitors based on their name. Type the monitor names to add them for monitoring. You can also use RegEx to filter any type of resource and add them for monitoring.

6. Define Actions: Use the drop-down menu and associate the following actions for your database monitors:

• User Profile: Manually add the name of the user profile that you wish to monitor. Press Enter to add multiple values.

• Tags: Associate tags for the particular monitor to organize and manage monitors creatively.

• Dependent on Monitor: Set up a dependent monitor, which would then suppress alerts sent to monitors if the selected monitor's status is Down.

• Dependent for Child Monitors: Set up a dependent monitor for the preferred child monitors, which would then suppress alerts if the selected child monitors' status is Down.

• Add Databases: Manually add the databases that you wish to monitor. Press Enter to add multiple values.

You can also use RegEx to filter any type of resource and add them for monitoring. A sample is shown below:

log.*|.*prod.*|.*transaction

 
This will match all the database names that start with log, contain prod, and end with transactions and add them for monitoring.

7. Select the type of automation you would like to execute from the IT Automation Templates and provide the necessary parameters to remediate routine actions automatically.

8. Click Save or Save and Run Rule to run the rule immediately.

Related articles  

Database monitoring: Oracle PDB | PostgreSQL | MySQL | Microsoft SQL | MySQL NDB Clusters