Returns information about the operating system volume
SELECT * FROM sys.dm_os_volumne_stats (database_id, file_id)
-- get data for all of the DBs:
SELECT ...
FROM sys.master_files f
CROSS APPLY sys.dm_os_volume_stats(f.database_id, f.file_id) vs
Note: Available from MSSQL 2008 R2 SP1.
No comments:
Post a Comment