1 2 3 4 5 6 7 8
| SELECT DB_NAME(f.database_id) AS [DatabaseName], f.file_id,
case f.max_size when -1 then 'UNLIMITED' when 268435456 then 'UNLIMITED' else cast(max_size/128 as varchar(32))
end as 'Max size MB',
vs.volume_mount_point, vs.total_bytes/1048576 as 'Total bytes MB on disk', vs.available_bytes/1048576 as 'Available MB on disk',
CAST(CAST(vs.available_bytes AS FLOAT)/ CAST(vs.total_bytes AS FLOAT) AS DECIMAL(18,1)) * 100 AS [Space Free % on disk]
FROM sys.master_files AS f
CROSS APPLY sys.dm_os_volume_stats(f.database_id, f.file_id) AS vs
ORDER BY f.database_id ; |
Partager