Page Comparison

...

...

Overview

The Index Fragmentation form provides a quick snapshot of the indexes in the Database that are fragmented more than the chosen value.  The MS Microsoft SQL recommendation is to not allow fragmentation over 30%, so the default value is set to 30.  This value can be altered. 

SQL Index Monitor User Interface

Table Column Meanings:

• Table Name : This is the table name that the index belongs to.
• Index Name: This is the name of the index.
• Type: This is the description of the index type.
• Frag %: This is the logical fragmentation for indexes, or extent fragmentation for heaps in the IN_ROW_DATA allocation unit.
• Index Sz: This is the actual size of the index.
• Defrag: Click the appropriate button to reorganize or rebuild the index.

How to use the Index Fragmentation Table

Double Clicking a Row

Double clicking a row on the Index Fragmentation Table will display a popup box with more detailed information about how that index is used.  This data is reset anytime the database is restarted for any reason. This can be used to help evaluate possible index clean up if the database has been running for a long period of time.  

Image RemovedImage Added

Table Color Meanings for Frag% > Fragmentation limit

...