Non Clustered Index Stats

<< Click to Display Table of Contents >>

Navigation:  In Memory Tables >

Non Clustered Index Stats

This is information about in memory non clustered indexes

 

 

Column

Description

Delta Pages

Total number of delta pages for the index

Internal Pages

Total number of internal pages for the index

Leaf Pages

Number of leaf pages for the index

Outstanding Retired Nodes

Number of nodes for the index

Page Update Count

Cumulative number of operations updating a page for the index

Page Update Retry Count

Retries of line above

Page Consolidation Count

Number of page consolidations for the index

Page Consolidation Retry Count

Retries of line above

Page Split Count

Cumulative number of page split operations for the index

Page Split Retry Count

Retries of line above

Key Split Count

Cumulative number of key split operations for the index

Key Split Retry Count

Retries of line above

Page Merge Count

Cumulative number of page merge operations for the index

Page Merge Retry Count

Retries of line above

Key Merge Count

Cumulative number of key merge operations for the index

Key Merge Retry Count

Retries of line above