posted

1 Comment

Kyle Wassink, Blue Medora

Databases are one of the most critical layers in the modern IT stack, making database monitoring a necessity. The need for comprehensive and proactive performance monitoring only increases with virtualization; critical memory and CPU resources are shared with virtual machines. Monitoring these critical layers, database and virtualization, is one of vRealize Operations Manager’s wheelhouses.

VMware’s vRealize Operations Manager (vROps) provides extensive monitoring of hosts, virtual machines, datastores, and other VMware layers out of the box. Various database monitoring solutions are available from VMware’s Solution Exchange. These management packs are extensively integrated with vROps and provide the insight needed to effectively manage your databases, virtualized or not.

Oracle Database Monitoring

As one of the most popular enterprise database solutions, monitoring Oracle databases often equates to monitoring your mission-critical databases. The Management Pack for Oracle Database does not disappoint, covering over 100 metrics for databases, queries, tablespaces and more. The 7 dashboards, 9 views, and 6 reports provided out of the box give you the comprehensive information you need in an easily accessible format. Integration with vROps capacity planning opens up numerous avenues for proactively identifying problems before they happen.

Figure1-Oracle Databse monitoring

Microsoft SQL Monitoring

Another popular database solution is Microsoft SQL, which can be monitoring in vROps with the Management Pack for Microsoft SQL Server. The pack collects over 140 metrics on SQL servers, SQL databases, and always on availability groups. With 10 dashboards, 10 views, and 5 reports, you will have comprehensive insights into your SQL stack. Extensive integration with capacity definitions ensure early detection of resource constraints.

Figure2-MicrosoftSQL database monitoring

SAP HANA Database Monitoring

As a market leader in big data analytics, SAP HANA is a popular choice for in-memory databases. Covered by the Management Pack for SAP HANA, you can monitor you HANA stack right in vRealize Operations. Numerous dashboards and metrics are covered out of the box, as well as thorough integration with capacity planning. Resource monitoring is critical for in-memory databases, and this pack has you covered.

Figure3-SAPHANA database monitoring

MySQL Database Monitoring

Providing visibility into your MySQL databases, tables, queries, and more is handled by the Management Pack for MySQL. With 5 dashboards, 5 views, and 5 reports available out-of-the-box, you’ll know everything going on in your MySQL instances. Hundreds of metrics and integration with capacity planning, as with the other solutions, ensure proactive detection of serious problems and resource shortages.

Figure4-MySQL database monitoring

PostgreSQL Database Monitoring

The Management Pack for PostgreSQL brings your PostgreSQL instances into vROps with over 100 metrics on databases, tables, queries, and more. Its 5 dashboards, 4 views, and 4 reports get you off the ground quickly after installation. As with every other database pack, these dashboards, views, and reports can be customized or cloned to meet your specific workflow needs.

Figure5-PostgreSQL database monitoring

Bonus: IBM DB2 Database Monitoring

The Management Pack for IBM DB2 integrates over 150 metrics from your DB2 environment into vROps. It has 4 dashboards, 7 views, and 5 reports provided out-of-the-box, as well as integration with capacity planning. Thorough alerting and recommendations are also provided, adding yet another way to ensure your DB2 instances are running smoothly.

Figure6-IBMDB2 database monitoring

Where to Get Database Solutions for vRealize Operations

If you want to add database monitoring to your environment, check out Blue Medora’s data-tier vROps management packs to find the solutions discussed above.