摘要:Data file size
查看Data file 的 size (不過UsedSpace的值不會即時, 需在下一次Insert/Update/Delete後才會正確)
SELECT
s.name AS [Name],
s.physical_name AS [FileName],
s.size * CONVERT(float,8) AS [Size],
CAST(FILEPROPERTY(s.name, 'SpaceUsed') AS float)* CONVERT(float,8) AS [UsedSpace],
s.file_id AS [ID]
FROM
sys.master_files AS s
WHERE
(s.database_id = db_id())
ORDER BY
[ID] ASC