The VMware Aria Operations Management Pack for Microsoft SQL Server is an embedded adapter for VMware Aria Operations, collecting performance data from your Microsoft SQL Server environment and providing predictive analytics and real-time information about problems in your infrastructure—all within the VMware Aria Operations user interface.
The Management Pack for Microsoft SQL Server includes the following notable features:
7 comprehensive monitoring dashboards, including:
Microsoft SQL Server DBA Overview – Get a bird's-eye view into the overall health and performance of your SQL Server instance
Microsoft SQL Server Database – Drill down into the performance details of your SQL databases, including index performance, database size break-down, disk capacity, status, and alerts
Microsoft SQL Server Query Plan – Generate query plans to help troubleshoot slow queries
Microsoft SQL Server VM Relationship – Gain visibility into the relationship between your virtual hosts and SQL Server instances, with the ability to view KPIs side-by-side
250+ collected metrics for Microsoft SQL Server resources
30+detailed alerts and notifications for critical and warning conditions
Capacity definitions for connection limit, CPU demand, memory usage, and disk capacity
External relationships from your VMware Virtual Machines to SQL Server Instance and Always On Availability Groups
How the Management Pack Works
The Management Pack for Microsoft SQL Server connects to your Microsoft SQL Server instancevia JDBC using the jTDS driver.SQL queries are executed in order to import health, performance, availability, capacity, and relationships data for your SQL server resources into VMware Aria Operations.
Wondering where to start? See System Requirements for details.