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:
Several query execution modes are available:
Execution of dynamically constructed insert/update/delete queries is also supported, allowing to alter remote tables upon AggreGate events.
Read more on: