1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| USE TempDB
GO
SELECT DF.name AS logical_name
, DF.physical_name AS physical_name
, DF.type_desc AS file_type_desc
, CASE DF.is_percent_growth
WHEN 0 THEN CASE DF.growth WHEN 0 THEN 'DISABLED' ELSE CAST(DF.growth / 128 AS varchar(20)) + ' MB' END
ELSE CAST(DF.growth AS varchar(3)) + ' %'
END AS growth
, CAST(DF.size / 128.0 AS decimal(14, 2)) AS file_size_MB
, CAST(FILEPROPERTY(DF.name, 'SpaceUsed') / 128.0 AS decimal(14, 2)) AS occupied_size_MB
, CASE DF.max_size
WHEN -1 THEN 'UNLIMITED'
WHEN 0 THEN 'DISABLED'
ELSE CAST(CAST(DF.max_size / 128.0 AS bigint) AS varchar(20))
END AS max_size_MB
FROM sys.database_files AS DF |
Partager