Users: 15,000+ | Page Views: 50,000+ | PPS: 2.5
TechDevOps.com
Explore Tools
{Experts in Microsoft SQL Server Operations, Performance, HA/DR, Data Migrations & Cloud Computing}



SQL Server 2017 - sys.dm_os_enumerate_fixed_drives
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
2017-06-24








Iteration #1:


SELECT * FROM sys.dm_os_enumerate_fixed_drives;

Msg 3634, Level 16, State 1, Line 3
The operating system returned the error '21(The device is not ready.)' while attempting 'GetDiskFreeSpace' on 'A:\'.


Workaround: You can disable the virtual Floppy drive from the Device Manager and re-run.



Iteration #2:

SELECT * FROM sys.dm_os_enumerate_fixed_drives;



As you can see there are duplicate records being returned from this new DMV and Microsoft will address that.

Note: This new DMV is a replacement for XP_FIXEDDRIVES.


Positioned Resources: