Monitoraggio dello spazio di storage dei file del database

[FrancyDotNet]

Codice: Seleziona tutto

SELECT
    DB_NAME(database_id) AS DatabaseName,
    name AS LogicalFileName,
    type_desc AS FileType,
    size / 128.0 AS FileSizeMB,
    FILEPROPERTY(name, 'SpaceUsed') / 128.0 AS SpaceUsedMB,
    (size - FILEPROPERTY(name, 'SpaceUsed')) / 128.0 AS FreeSpaceMB
FROM
    sys.database_files;