SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

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 .

SQL Geek

Dharmendra is a SQL Server/Microsoft Data Platform professional with over eight years of experience. He enjoys helping others in the SQL Server community and does this by contributing on blogs, speaking at several SQL events. His passion and focus is to explore and share more and more on SQL Server.

Comments

Leave a comment on the original post [www.dharmendrakeshari.com, opens in a new window]

Loading comments...