SQL Server 2017 sys.dm_os_enumerate_fixed_drives

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

New Way

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

Leave a comment

Your email address will not be published. Required fields are marked *