SQL Server/T-SQL Tutorial/System Functions/fn virtualfilestats

fn_virtualfilestats returns I/O statistics for a database file

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>