The <DATABASE_SYSTEM_ADMINISTRATOR>.MONITOR_PAGES monitor system table contains information about accesses to the pages.
Value |
Explanation |
---|---|
Virtual reads |
Number of virtual read operations |
Virtual writes |
Number of virtual write operations |
Physical reads |
Number of physical read operations |
Physical writes |
Number of physical write operations |
Catalog virtual read |
Number of virtual catalog read operations |
Catalog virtual writes |
Number of virtual catalog write operations |
Catalog physical reads |
Number of physical catalog read operations |
Catalog physical writes |
Number of physical catalog write operations |
Perm page virtual reads |
Number of virtually read permanent pages |
Perm page virtual writes |
Number of virtually written permanent pages |
Perm page physical reads |
Number of physically read permanent pages |
Perm page physical writes |
Number of physically written permanent pages |
Temp page virtual reads |
Number of virtually read temporary pages |
Temp page virtual writes |
Number of virtually written temporary pages |
Temp page physical reads |
Number of physically read temporary pages |
Temp page physical writes |
Number of physically written temporary pages |
LOB page virtual reads |
Number of virtually read pages for LOB columns |
LOB page virtual writes |
Number of virtually written pages for LOB columns |
LOB page physical reads |
Number of physically read pages for LOB columns |
LOB page physical writes |
Number of physically written pages for LOB columns |
Leaf page virtual reads |
Number of virtually read leaf pages |
Leaf page virtual writes |
Number of virtually written leaf pages |
Leaf page physical reads |
Number of physically read leaf pages |
Leaf page physical writes |
Number of physically written leaf pages |
Level1 page virtual reads |
Number of virtually read index pages at level 1 |
Level1 page virtual writes |
Number of virtually written index pages at level 1 |
Level1 page physical reads |
Number of physically read index pages at level 1 |
Level1 page physical writes |
Number of physically written index pages at level 1 |
Level2 page virtual reads |
Number of virtually read index pages at level 2 |
Level2 page virtual writes |
Number of virtually written index pages at level 2 |
Level2 page physical reads |
Number of physically read index pages at level 2 |
Level2 page physical writes |
Number of physically written index pages at level 2 |
Level3 page virtual reads |
Number of virtually read index pages at level 3 |
Level3 page virtual writes |
Number of virtually written index pages at level 3 |
Level3 page physical reads |
Number of physically read index pages at level 3 |
Level3 page physical writes |
Number of physically written index pages at level 3 |
Level4 page virtual reads |
Number of virtually read index pages at level 4 |
Level4 page virtual writes |
Number of virtually written index pages at level 4 |
Level4 page physical reads |
Number of physically read index pages at level 4 |
Level4 page physical writes |
Number of physically written index pages at level 4 |
Level5 page virtual reads |
Number of virtually read index pages at level 5 |
Level5 page virtual writes |
Number of virtually written index pages at level 5 |
Level5 page physical reads |
Number of physically read index pages at level 5 |
Level5 page physical writes |
Number of physically written index pages at level 5 |
Level1 page safeness applied |
Number of safeness checks on primary b* tree level one |
Level1 page safeness approved |
Number of successful safeness checks, i.e. the b* tree structure could be changed without locking the complete b* tree |
Converter page virtual reads |
Always 0 |
Converter page virtual writes |
Always 0 |
Converter page physical reads |
Number of physically read converter pages |
Converter page physical writes |
Number of physically written converter pages |
Clustered virtual reads |
Number of clustered virtual reads |
Clustered page virtual reads |
Number of virtually read clustered pages |
Pages marked for reclustering |
Number of pages marked for resolving clusters |
Cluster compression segment reads |
Number of segments (with size DataIOClusterSize) read by cluster compression to free these segments. Equal to number of I/O calls made for cluster compression. |
Cluster compression block reads |
Number of blocks read into temporary buffer (physical I/O) |
Cluster compression pages handled |
Number of pages relevant for cluster compression and set to status changed |