Returns I/O statistics for data and log files. This dynamic management view replaces the fn_virtualfilestats function.
ID of database.
ID of file.
Number of milliseconds since the computer was started. This column can be used to compare different outputs from this function.
Number of reads issued on the file.
Total number of bytes read on this file.
Total time, in milliseconds, that the users waited for reads issued on the file.
Number of writes made on this file.
Total number of bytes written to the file.
Total time, in milliseconds, that users waited for writes to be completed on the file.
Total time, in milliseconds, that users waited for I/O to be completed on the file.
Number of bytes used on the disk for this file. For sparse files, this number is the actual number of bytes on the disk that are used for database snapshots.
Windows file handle for this file.
Requires VIEW SERVER STATE permission. For more information, see Dynamic Management Views and Functions (Transact-SQL).