Management Pack for Microsoft SQL Server

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.

Notable Features

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.

Getting Started

Wondering where to start? See System Requirements for details.