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

Analysis Badge Example - Reclaimable Capacity


analysis_badge-3