1 2 3 4 5 6 7 8 9 10 11 12 13
| SELECT DB_NAME(mf.database_id) AS DB,name AS F_NAME, type_desc,
physical_name, state_desc,
CAST(size / 128.0 AS DECIMAL(16, 3)) AS SIZE_MB,
CAST(max_size / 128.0 AS DECIMAL(16, 3))AS MAX_SIZE_MB,
CASE is_percent_growth
WHEN 1 THEN CAST(growth AS VARCHAR(32)) + ' %'
ELSE CAST(CAST(growth / 128.0 AS DECIMAL(16, 3)) AS VARCHAR(32)) + ' MB'
END AS GROWTH_TYPE,
is_media_read_only, mf.is_read_only, volume_mount_point,
CAST(total_bytes / 1073741824.0 AS DECIMAL(16, 3)) AS VOLUME_SIZE_GB,
CAST(100.0 * available_bytes / total_bytes AS DECIMAL(16, 3)) AS FREE_VOL_PERCENT
FROM sys.master_files AS mf
CROSS APPLY sys.dm_os_volume_stats(mf.database_id, mf.file_id) AS vs; |
Partager