SELECT
@@SERVERNAME As 'Server Name',
DB_NAME(dbid) As 'Database Name',
physical_name As 'File Name',
Type_Desc As 'File Type',
NumberReads As '# of Reads',
BytesRead As 'Bytes Read',
NumberWrites As '# of Writes',
BytesWritten As 'Bytes Written',
IoStallReadMS As 'IO Stall Read',
IoStallWriteMS As 'IO Stall Write',
IoStallMS As 'Total IO Stall (ms)',
GETDATE() As 'Collection Date'
FROM
fn_virtualfilestats(NULL,NULL) vfs
inner join sys.master_files mfi ON vfs.dbid = mfi.database_id AND vfs.fileid = mfi.file_id
ORDER BY
DB_NAME(dbid)
|
|
|
|
|
|