Database Files Usage Statistics
SELECT
@@SERVERNAME 'Instance Name',
UPPER(DB_NAME(dbid)) 'Database Name',
physical_name 'File Name',
[Type_Desc] 'File Type',
NumberReads 'Number of Reads',
BytesRead 'Bytes Read',
NumberWrites 'Number of Writes',
BytesWritten 'Bytes Written',
IoStallReadMS 'IO Stall Read (ms)',
IoStallWriteMS 'IO Stall Write (ms)',
IoStallMS as 'Total IO Stall (ms)',
GetDate() as 'Date Collected'
FROM
fn_virtualfilestats(NULL,NULL) fs INNER JOIN
sys.master_files mf ON fs.dbid = mf.database_id
AND fs.fileid = mf.file_id
AND database_id not in (1,3,4) --filter out master, msdb, model
ORDER BY
DB_NAME(dbid)
|
|
|
|
|
|