Database Query Monitor

Introduction:

This section is common to all the editions of IT360 - Professional Edition, Enterprise Edition (Probes only) and MSP Edition (Probes only).

Database Query Monitor is used to monitor a single query or a set of queries, for any given database. This SQL based query monitor allows the user to monitor the status of that particular query.

Steps to add a Database Query Monitor:

To add a Database Query Monitor, follow the below steps;

1. Go to 'Admin -> Servers & Applications' and click on New Monitor link.

2. Choose Database Query Monitor from the Add Monitor of type drop down.

3. Enter the Display Name of the Monitor.

4. Enter the Host Name / IP Address of the Monitor, on which the database is running.

5. Enter the Port number.

6. Select the Database type for which the query is being executed.

7. Enter the Username and Password of the database server.

8. Enter the Database name.

9. Enter the  JDBC Url. This is an optional field only.

10. Enter the Query(ies). Please note that the number of queries is limited to five. In addition, note that the delimiter for a query is new line.

11. Select whether you would prefer Query Output, by choosing the Yes or No radio button.

12. Enter the Polling Interval. By default, it is 5 minutes.

13. Choose the Business Service from the combo box, with which you want to associate the Database Query monitor;

    • In the case of Professional Edition, it is Business Service [optional].

    • In the case of Enterprise Edition - Probe, it is Business Service [optional].

    • In the case of MSP Edition - Probe, it is Customer and Site [mandatory].

14. Click Add Monitor(s). This discovers the Database Query Monitor from the network and starts monitoring them.

15. Upon adding the Database Query monitor, you can view the details of the newly added Monitor.

Top

See Also:

Create Other New Monitors