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!

Leave a comment

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