udb.io_file_stats


The udb.udb.io_file_stats table is used to hold data from the sys.dm_os_virtual_file_stats() DMV (function).  Data is normally written to this table from the udb.gather_io_file_stats procedure.

.

Column name Data type Description
record_date datetime The date and time the record was  written
database_id smallint The id of the database
file_id smallint The id of the file for a particular database
num_of_reads bigInt Number of read execution on the give database_id/file_id combination since the restart of the SQL Server service.
num_of_bytes_read bigInt Number of bytes read from the database_id/file_id since the restart of the SQL Server service.
io_stall_read_ms bigInt Milliseconds of wait due to read  operations waiting on the disk subsystem since the restart of the SQL Server service.
num_of_writes bigInt Number of write operations on the give database_id/file_id combination since the restart of the SQL Server service.
num_of_bytes_write bigInt Number of bytes written to the database_id/file_id since the restart of the SQL Server service.
io_stall_write_ms bigInt Milliseconds of wait due to write operations waiting on the disk subsystem since the restart of the SQL Server service.
io_stall bigInt Milliseconds waiting on the disk subsystem since the restart of the SQL Server service.
size_on_disk_bytes bigInt Total size of the database_id/file_id at the given point in time.

 




See Also

udb.gather_io_file_stats

udb.io_file_stats_overview

 

[First seen in Release 2.0]

[Last Changed in Release 2.0]

 

Last edited Aug 20, 2014 at 1:38 AM by sfibich, version 8

Comments

No comments yet.