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!
One thought on “SQL Server 2017 sys.dm_os_enumerate_fixed_drives”
Yeah agreed https://akawn.com/blog/2017/04/sql-server-2017-sys-dm_os_enumerate_fixed_drives “Not including the drive capacity requires the DBA to perform additional computations to extract the information”