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

Live Sample Reports

Server Network Response Time
DHCP Response Time
LDAP Response TimeServer
Router Interface Traffic
SQL Server Resource Utilization
Server CPU Usage
Bandwidth Utilization
Server Memory Utilization
SMTP/POP Mail Response
Web Page Download Time

NimBUS for Database Monitoring

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.

NimBUS monitors and reports on the status of server resources with, or without, a business service context. NimBUS 'service-centric' server monitoring helps IT gain a business service perspective from the multitude of server platforms they have deployed.

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:
- Sybase
- Informix
- Oracle
- MS SQL
- DB2

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

NimBUS 'Service-centric' Database Monitoring

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.

NimBUS 'Server-centric' Database Monitoring

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.

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.

Operative Software Products 7219 Kentwood Avenue Los Angeles, Ca 90045 Toll Free (866) 204-6289
© 2007 Operative Software Products