Analysis Badges and Capacity Definitions (Microsoft SQL Server)

Using the predictive analytics capabilities of vRealize Operations Analysis Badges through capacity definitions, the Management Pack for Microsoft SQL Server populates capacities as listed in the table below.

MS SQL Database Capacities

Container	Use in Workload
Database Disk Capacity
Reserved disk space* vs. Effective free disk space *Database disk space usage (including allocated but unused) measured against free disk space on drives the database resides on	yes

MS SQL Server Instance Capacities

Container	Use in Workload
Connection Limit
Number of connections* vs. Number of possible connections *Connection usage as reported by MS SQL Server (includes active and idle)	yes
CPU Demand
CPU Usage* vs. Maximum CPU Usage *Usage percent of Host CPU used by MS SQL Server application measured by MS SQL Server	yes
Memory Usage
Effective Memory* vs. Total Server Memory *Host RAM in use by MS SQL Server application measured by MS SQL Server	yes
Disk Capacity
Used Disk Space* vs. Total Disk Space *Aggregate Disk usage on all disks the MS SQL Server uses reported by MS SQL Server	yes