sys.dm_os_enumerate_fixed_drives (Transact-SQL)
Starting with SQL Server 2017 (14.x) CU 1, sys.dm_os_enumerate_fixed_drives enumerates volumes mounted to drive letters like C:\.
| Column name | Data type | Description |
|---|---|---|
fixed_drive_path |
nvarchar(512) | Path to the volume, like C:\. |
drive_type 1 |
int | Code for drive type. |
drive_type_desc 1 |
nvarchar(512) | Description of drive type. |
free_space_in_bytes |
bigint | Disk free space in bytes. |
1 For more information, see the GetDriveTypeW function.
Permissions
For SQL Server 2019 (15.x) and previous versions, requires VIEW SERVER STATE permission on the server.
For SQL Server 2022 (16.x) and later versions, requires VIEW SERVER PERFORMANCE STATE permission on the server.