Mega Code Archive

 

Categories / MSSQL Tutorial / System Functions

 

Fn_virtualfilestats returns IO 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>