Solutions > Network Management > Database Monitoring

Database Monitoring

	Database Monitor Configuration

AggreGate Network Manager helps database administrators (DBAs) and system administators to diagnose and fix database server failures and performance issues. Using JDBC/ODBC connectivity, the Network Manager can remotely connect to any widespread database engine, including Oracle, MySQL, Microsoft SQL Server, Firebird, Sybase, IBM DB2, and other.

Query Result Analysis

The Network Manager executes arbitrary SQL queries, converts their result sets into AggreGate format and stores in the AggreGate Server's own database for later analysis. The queries may be dynamically constructed using AggreGate Expression Language.

Processing methods for data retrieved from external databases include:

• Displaying pre-processed values on the dashboards
• Custom alerting if table data matches a certain condition
• Scheduled emailing of printable reports based on SQL query results

  	SQL Result Set

• And more

Several query execution modes are available:

• Periodic or scheduled
• On event or alert
• On demand

Execution of dynamically constructed insert/update/delete queries is also supported, allowing to alter remote tables upon AggreGate events.

Database Performance Diagnosis

Skilled DBAs plan inventory requirements in advance by predicting database performance trends for the near future. AggreGate Network Manager facilitates such planning by providing performance statistics for "probe queries".

In addition, the system may raise an alert if execution time of a certain query crosses a given threshold. Once received an alert notification via SMS or email, the database administrator may start investigating the issue immediately.

Get Free Trial

Compare Editions

Purchase Online