The Blue Medora vRealize Operations (vROps) Management Pack for Microsoft SQL Server offers end-to-end relational visibility into the workloads running on Microsoft SQL Server.
Gain critical actionable insight into database performance, query designs, and queries with the vRealize Operations Management Pack for Microsoft SQL Server. In the vROps console access 250+ collected metrics, dashboards, reports, notifications and alerts to clearly understand how workloads are performing, where issues may occur, and their source. Write better queries and optimize query designs for faster information retrieval and reporting.
This Management Pack enables administrators to discover query design problems with minimal effort, analyze individual queries with the most expensive execution times, plus provides predictive analytics and real-time information about problems in your infrastructure. As a result, you gain end-to-end relational visibility into the performance and health of Microsoft SQL Server workloads and their related environments—all within the vRealize Operations user interface.
End-to-end relational visibility. Find out why queries are performing poorly with query plans. Leverage internal and external relationships for maximum visibility into Microsoft SQL Server.
Health awareness. Gain deep insight into capacity and performance issues with out-of-the-box dashboards and reporting capabilities.
Relationship mapping. View relationships between Microsoft SQL Server and the virtual layer.
Alerts and notifications. Gain access to instant alerts to quickly identify and pinpoint issues.
Performance, health, and availability data are collected for the following Microsoft SQL Server resource kinds:
The Management Pack for Microsoft SQL Server enhances VMware vRealize Operations Manager by adding 7 dashboards, including:
Right-size capacity and licensing with contextual visibility across your data tier, and its related infrastructure.
The automatic alerts enable administrators to pinpoint the source of issues before they cause a major impact. In addition, capacity definitions such as CPU demand, memory usage and disk capacity are easily available. Identify urgent corruption and backup failures instantly.