fn_virtualfilestats returns I/O statistics for a database file : fn_virtualfilestats « System Functions « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Functions
3. fn_virtualfilestats

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>