1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| USE Mabase;
GO
DBCC UPDATEUSAGE (0)
GO
SELECT F.name, F.physical_name, FG.name, CAST(size AS BIGINT) * 8 AS data_size_Ko,
CAST(max_size AS BIGINT) * 8 AS max_size_Ko,
SUM(CAST(size AS BIGINT) * 8 ) OVER(PARTITION BY FG.name) AS data_space_size_Ko,
SUM(CAST(size AS BIGINT) * 8 ) OVER() AS data_base_size_Ko,
volume_mount_point, logical_volume_name,
total_bytes / 1024 AS total_disk_Ko,
available_bytes / 1024 AS free_disk_Ko
FROM sys.database_files AS F
LEFT OUTER JOIN sys.filegroups AS FG
ON F.file_id = FG.data_space_id
CROSS APPLY sys.dm_os_volume_stats(DB_ID(), F.file_id); |
Partager