MONITOR_PAGES

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