DBSonar Overview
DBSonar continuously monitors database systems for potential problems and issues precautious alerts for you to solve these problems before they impact end-users. It also provides analyses and suggestions with real-time and historical resource consumption data, allowing system administrators to make informed decisions in handling exceptions or planning resources. DBSonar's SQL convergence and drill-down techniques with cross-linked association of data help you to debug performance issues with ease. With DBSonar on your side, you have the assurance of having a 24x7 Informix database expert with you.

It is an endless challenge for database administrators (DBAs) to maintain large and complex database environments, while keeping them working smoothly. The database system usually generates a number of warning messages before the actual performance slowdown or system failure. However, such messages are often too hard to decipher by the DBAs, who are unable to take preventive actions before serious damage is caused.

Maintaining a constant level performance is a daunting task because a great deal of factors contribute to system performance, including CPU, memory allocation, or disk access. Configuration of system parameters or the behavior of SQL commands issued by applications also affect performance. The problem itself only shows the outcome and the real cause is usually hard to find. This uncertainty causes the problems to be attributed to insufficient resources, leading to system expansion. In reality, this doesn't really solve the problem, which is bound to recur again.

In essence, the DBA's mission-critical job is to prevent problems and respond instantaneously at the first sign of trouble, so that problems can be solved at the first opportunity and the system can continue to run smoothly. DBSonar helps you accomplish just this and with simplicity. DBSonar's unique features provide the perfect set of diagnostic tools that a DBA needs to maintain high quality server performance.

◎   System Architecture
The Java-based client provides the front-end console and communicates to production servers through JDBC/ssh connections. Multiple servers can be centrally managed from a single console. The server-side monitoring agent runs at the production database server in the background. Periodically, it collects information on important system activities, stores it on a repository database, and sends it out to the front-end for processing. This design minimizes the impact on network bandwidth, leaving the target system to operate at maximum performance.

◎   Main Fuction
■   Real-Time Performance Monitoring
■   Automated Event Notifications
■   Drill-down Analysis
■   Datdbase Health Check
■   Cross-linked Association
■   SQL Convergence
■   Secure Working Environment

◎   Related Links
■   DBSonar Online Tutorials
■   DBSOnar Demo
■   DBSonar 30days Evaluation