Databases store vital information required to run the enterprise efficiently and hence plays an integral role in the performance of an organization. The infrastructure availability weighs heavily on the database performance and any minor outage or slowdown can adversely affect the business. Tracking or monitoring databases help database administrators to analyze the application and take appropriate actions before it affects the end-users. The administrators can view the metric graphs to validate the performance and availability of the resource. For example, the metrics collected are:

  • CPU utilization
  • Total storage capacity
  • Used storage capacity
  • Maximum connection limits
  • System uptime
  • Current active and inactive session
  • Session utilization

Using database monitoring, administrators can get:

  • Improved end-user performance.
  • Increased response time and database availability.
  • Troubleshooting issues before it affects the end-users.

Supported database monitors

  • Apache Cassandra
  • CockroachDB
  • CouchBase
  • CouchDB
  • DB2
  • MongoDB
  • MSSQL
  • MySQL
  • OracleDB
  • PostgreSQL
  • Sybase

Database monitoring process flow

Database Monitoring Process Flow

Visualization

Dashboard

After initiating the database monitoring, use dashboard to gather customized visibility of the resources in your managed environment. Create widgets such as Metric Value, Time Series, Metric List, and Top Metric Utilization to track the performance of the resources.

Database Monitoring Dashboard

Alerts

The alerting process automatically detects the performance issues and sends alerts to the administrators.

Generate alerts

Determine whether to generate alerts while you are configuring the metric thresholds and frequency.

Generate Alerts

Set notifications

Setting notifications for any alert using email, SMS or voice can notify the administrator about the issue. For more information, see Manage Alert Notifications.

Notification Preferences