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. Login to IT360 console with the Username and Password of an Admin user.

  2. Click the Admin tab in the header pane.

  3. Click Discover/Add under Discovery.

  4. Choose the option Add from the Discover / Add type dropdown and select the Application radio button.

  5. In the Add New Monitor wizard displayed, click Query Monitor under Custom Monitors. Fill-in the following details:

  6. Enter the Display Name of the Monitor.

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

  8. Enter the Port number.

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

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

  11. Enter the Database name.

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

  13. 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... Also, the row count per DB Query should not exceed 50.

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

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

  16. Now, Associate the above Monitor Instances to a Business Service. i.e. choose the Business Service, to which you want to associate the Database Query Monitor, from the combo box. If no Business Service is found, Create one by clicking the Create New Business Service link.

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

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

Top

See Also:

Create Other New Monitors



Copyright © 2014, ZOHO Corp. All Rights Reserved.