Database Query Monitor

Introduction:

This section is common to all the editions of IT360, as per the below constraints;

Monitor Information:

Database Query Monitor is used to monitor a single or a specific set of queries, for any given database;

Using a single query, or a given set of queries, you can monitor the status of any given database, by using IT360 Database Query monitor. Queries are the best mode, to find out whether your database is up and running, 24x7. In Business enterprises, such as Online store, there are a number of Applications and Databases, which are used for e-commerce. Any interruption in such environment, could mean only one thing: Loss of revenue.

The execution of such a query, or a set of queries, can be automated, by setting Polling interval. By fixing the polling interval, user can automate this process, and the results are obtained at the end of the polling. The result includes execution time (time taken by the query to provide results), and also displays any error that may occur during regular polling intervals. These errors help in identifing any issue that may occur with the database.

Let us consider an example: Many enterprise environments run critical applications, which need to be up and running 24x7. Lets assume, the status of such applications are maintained in a 'APPLICATION_STATUS' table. Using the Database Query monitor, the user shall be able to send a select set of queries to that database, to find out, if they are operational or not.

|-----------------------------------------------------------|

| APPLICATIONS_STATUS                     |

|-----------------------------------------------------------|

| APPLICATIONS_NAME   | Status         |

|-----------------------------------------------------------|

| PURCHASE                    | OK             |

| CRM                               | CRITICAL    |

| PAYROLL                       | OK             |

| LEADS                           | OK             |

|-----------------------------------------------------------|

SELECT * APPLICATIONS_STATUS:

By executing the above command, by using the Database Query monitor, the user will be able to obtain the list of applications that are running, along with its status. The user can then identify the applications, whose status is 'Critical', and then carry out the necessary action, by configuring Alerts in IT360. This action could be in the form of creating a ticket, or executing a script, to rectify the problem.

The Database Query monitor can also be used to identify any bottle necks in the networks, that are linked to several databases, and help remove them, by identifying the correct database which has the issue. This bottle neck issue arises, generally, due to a problem, with one of applications, or with the databases. Using the Database Query monitor, the user can then execute a given set of queries, and analyze the result, which provides a clear indication of the error that has caused such an occurance. The result includes the execution time (time taken by the query to generate the result). If the execution time is above a certain pre-assigned threshold, then the issue is with the database, or if the result is below the pre-assigned threshold, then the issue is elswhere.

The Database Query monitor currently supports the following set of databases queries;

IT360 also provides the ability to compare various column values in the output, by attributes types. In addition, option to Enable or Disable Reports, is also provided.

Note: Please note that the number of queries is limited to five. Total number of rows shown in the output is limited to 50 rows.

 

Top

See Also:

Creating New Monitor - Database Query Monitors



Copyright © 2013, ZOHO Corp. All Rights Reserved.