udb.io_file_stats_overview


(In progress)

.

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

 

[First seen in Release 2.0]

[Last Changed in Release 2.0]

Last edited Aug 20, 2014 at 2:37 AM by sfibich, version 2

Comments

No comments yet.