SQL Server 2017 sys.dm_os_enumerate_fixed_drives

Now there is another way to identify free disk space in SQL Server 2017.

SELECT * FROM sys.dm_os_enumerate_fixed_drives;

What I don’t understand is why Microsoft doesn’t include the capacity of the drive. Not including the drive capacity requires the DBA to perform additional computations to extract the information.

Leave a Reply