Collecting Disk Capacity and Free Space Metrics in SQL Server
Monitoring storage consumption is a routine operational task. SQL Server exposes several way to inspect disk space, ranging from quick checks to more complete inventories that include total capacity. Quicck check: xp_fixeddrives (free space only) xp_fixeddrives shows the current free space (in MB) f...