NimBUS for Database Monitoring

Summary:
The NimBUS for Database Monitoring solution monitors a wide array of availability and performance metrics for database servers. Additionally, the solution monitors SQL query response times and transaction rates. The solution supports multiple database platforms: Oracle, Sybase, DB2, MS SQL, and Informix. All database status data is analyzed for realtime alert generation, archived for performance reporting, and leveraged for SLA creation, monitoring and reporting.

While it is of utmost importance to monitor the database for high availability and peak performance, it is equally important (if not more important) to monitor the database in the context of the business service it supports.

The NimBUS for Database Monitoring solution provides service-based database monitoring (monitoring database response times from an end-user's perspective) and server-based database monitoring (monitoring database server integrity). The end goal of the NimBUS for Database Monitoring solution is to ensure the database is always available and running at peak performance so it does not compromise the business services it supports.

Primary Features:

Provides realtime, 7x24 database health check monitoring
Monitors database availability, performance and SLA compliance
Web-based status dashboards for CIO, Database Managers and DBAs
Historical archive for performance and SLA reporting
Support for cross-platform business environments:

Additional Features

Database cluster monitoring
Monitors database event logs
Monitors active users
Centralized and remote monitoring capabilities
Database resource utilization monitoring and reporting
Broad alert notification options - SMS, Cell, Pager, Email
"Profile-based" monitoring definition - unique monitoring defined per database
Realtime alerting and reporting for dozens of key database performance indicators
Reads and analyzes database table entries for alert generation and trend reporting

Service-centric database monitoring to ensure a high quality end-user experience - The NimBUS for Database Monitoring solution utilizes the NimBUS ADO (ActiveX Data Objects) Database Gateway to perform reads and writes into the monitored database system. When the ADO Gateway is executed against the target database it will return the transaction response time and also the number of rows the SQL returned. The NimBUS for Database Monitoring solution applies the ADO Gateway to monitor database availability and performance from an end-user's perspective. Additionally, the NimBUS ADO Database Gateway is applied to read data within database tables - response time data and table data collected by the ADO Gateway is analyzed for alert generation and archived for performance and SLA reports.

Server-centric database monitoring to ensure database server integrity and peak performance - The NimBUS for Database Monitoring solution includes a specialized database server resident probe; the probe will be platform specific. The specialized probe targets a wide array of database metrics to ensure status awareness for DBAs and Database Managers. As with the service-centric monitoring approach discussed above, the poll values for each database metric will be analyzed for alert generation and can also be automatically forwarded to the NimBUS for Database Monitoring historical archive - once there, availability and performance trend reports can be generated. Reports are key to provide insights on database server reliability, resource utilization, and more.

"Our clients rely upon DBA Zone as a trusted partner for all their database administration and monitoring needs. We needed a reliable monitoring solution that offered both real time and historical reporting capabilities"

"Not only has the Nimsoft product exceeded our expectations, but we have received top quality assistance from their support team both during and after the implementation."

Delana Sandy, President DBA Zone.

Database Performance and Historical Trend Reporting

The NimBUS for Database Monitoring solution provides historical performance reporting - this functionality will provide the necessary visibility to foresee and disrupt trends that may impact database service levels if allowed to persist. Trend reports also provide visibility into database resource consumption - this is key for proactive capacity planning. Database report examples include:

Transaction rates - reports reveal database efficiency and possibly business productivity
Database query response times - reports reveal database response time for read and write operations - degrading response times may indicate degrading end-user productivity
Disk space utilization - reports reveal consumption trends for proactive capacity planning
CPU utilization - reports reveal utilization trends, ideal for planning additional capacity or for load balancing
Number of active users - if trend shows an increase in active users you may consider purchasing additional user licenses to avoid license limitation issues

Monitoring Databases against Service Level Agreements

The NimBUS for Database Monitoring solution provides a SLA creation, monitoring and reporting function. This functionality makes it possible to map database performance metrics into an SLA that defines database service level objectives (SLO). Achieving service level objectives is key to ensure the database is able to accommodate desired transaction rates and high volume database queries. The SLA monitoring solution will continuously analyze database performance and perform calculations to determine if the database SLA is safely in compliance, it will also determine if a SLA breach is imminent if a problem condition is allowed to persist. The SLA solution includes a color-coded SLA compliance/breach trend indicator - alerts can be generated when % compliance decreases below a predefined threshold.

Please select a database platform link below to see the full compliment of monitored metrics: