SQL Server/T-SQL Tutorial/System Functions/fn virtualfilestats
fn_virtualfilestats returns I/O statistics for a database file
<source lang="sql">
5> 6> SELECT * FROM ::fn_virtualfilestats(5, 1) 7> GO DbId FileId TimeStamp NumberReads BytesRead IoStallReadMS NumberWrites BytesWritten IoStallWriteMS IoStallMS BytesOnDisk FileHa ndle
------ ----------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ------
(0 rows affected) 1> 2></source>