sqlserver可用空间

SELECT 
    DB_NAME(database_id) AS DatabaseName,
    CAST(SUM(size) * 8.0 / 1024 AS DECIMAL(18, 2)) AS TotalSizeMB,
    CAST(SUM(FILEPROPERTY(name, 'SpaceUsed')) * 8.0 / 1024 AS DECIMAL(18, 2)) AS UsedSizeMB,
    CAST(SUM(size) * 8.0 / 1024 - SUM(FILEPROPERTY(name, 'SpaceUsed')) * 8.0 / 1024 AS DECIMAL(18, 2)) AS FreeSpaceMB
FROM 
    sys.database_files;

SELECT 
    name AS FileName,
    CAST(size * 8.0 / 1024 AS DECIMAL(18, 2)) AS TotalSizeMB,
    CAST(FILEPROPERTY(name, 'SpaceUsed') * 8.0 / 1024 AS DECIMAL(18, 2)) AS UsedSizeMB,
    CAST(size * 8.0 / 1024 - FILEPROPERTY(name, 'SpaceUsed') * 8.0 / 1024 AS DECIMAL(18, 2)) AS FreeSpaceMB
FROM 
    sys.database_files
WHERE 
    type_desc IN ('ROWS', 'LOG');

SELECT 
    DB_NAME(database_id) AS DatabaseName,
    file_id,
    name AS FileName,
    CAST(size * 8.0 / 1024 AS DECIMAL(18, 2)) AS TotalSizeMB,
    CAST(FILEPROPERTY(name, 'SpaceUsed') * 8.0 / 1024 AS DECIMAL(18, 2)) AS UsedSizeMB,
    CAST(size * 8.0 / 1024 - FILEPROPERTY(name, 'SpaceUsed') * 8.0 / 1024 AS DECIMAL(18, 2)) AS FreeSpaceMB
FROM 
    sys.dm_db_file_space_usage;