In SQL Server 2017,  you can use the new DMV sys.dm_os_enumerate_fixed_drives to identify free disk space. The DMV is replacement of xp_fixeddrives.

Old way

XP_FIXEDDRIVES

New Way

SELECT * FROM sys.dm_os_enumerate_fixed_drives;

I wish Microsoft could have included the capacity of the drive. Not including the drive capacity requires the DBA to perform additional computations to extract the information.

Hope, Enjoyed Learning!

The post SQL Server 2017 sys.dm_os_enumerate_fixed_drives appeared first on .