数据库获得数据库物理文件的信息

2015-05-19 09:23:32  访问(1527) 赞(0) 踩(0)

SELECT dbf.file_id AS FileID
    , dbf.name AS [FileName] 
    , s.filename AS FileLocation
    , CAST(dbf.size/128.0 AS DECIMAL(19,2)) AS FileSizeMB
    , CAST(CAST(FILEPROPERTY(dbf.name, 'SpaceUsed') AS int)/128.0 AS DECIMAL(19,2)) AS SpaceUsedMB
    , CAST(dbf.size/128.0 - CAST(FILEPROPERTY(dbf.name, 'SpaceUsed') AS int)/128.0 AS DECIMAL(19,2)) AS AvailableSpaceMB
    , CAST((dbf.size / 128.0 - (FILEPROPERTY(dbf.name, 'SpaceUsed') / 128.0)) / (dbf.size / 128.0) * 100 AS DECIMAL(19,2)) AS [%FreeSpace]
    , dbf.growth / 128 AS FileGrowthMB
    , f.name AS FilegroupName
FROM sys.database_files dbf
    INNER JOIN sys.sysfiles s ON dbf.name = s.name
    LEFT JOIN sys.filegroups f ON dbf.data_space_id = f.data_space_id
ORDER BY dbf.name;

标签：数据库获得数据库物理文件的信息 

上一条：

下一条：

相关评论

发表评论

类型：	留言 建议 疑问
内容：
	(Alt+Enter)