Network Monitoring and Management
Network Monitoring and Management Software
AggreGate Platform

Database Monitoring

AggreGate Database Monitoring

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, InterSystems Caché, and other.

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.

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
  • 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.

Read more on:

Contact Us:

Send