Name 

Type 

Description 

instance_id 

INTEGER 

Server instance id. References sysinstances (id) 

id 

BIGINT 

Table id. References systables (id) 

deletes_sec 

INTEGER 

Current rate of deletes per second 

inserts_sec 

INTEGER 

Current rate of inserts per second 

updates_sec 

INTEGER 

Current rate of updates per second 

selects_sec 

INTEGER 

Current rate of selects per second 

cache_hit_ratio 

INTEGER 

Current cache hit ratio percentage for the database pages of the table 

cache_page_io_sec 

INTEGER 

Current rate of pages being read from the cache per second 

disk_page_io_sec 

INTEGER 

Current rate of pages being read from disk per second 

file_size 

INTEGER 

Size of the table's file on disk in MB 

page_split_sec 

INTEGER 

Current rate of B+tree page splits per second 

page_alloc_sec 

INTEGER 

Current rate of allocated pages per second 

page_free_sec 

INTEGER 

Current rate of freed pages per second 

ncount 

INTEGER 

Approximate number of rows in the table. copied from systables, used by optimizer. 

dpages 

INTEGER 

Number of B+Tree data leaf pages in the table. copied from systables, used by optimizer.