Index Health
—
Last scan: —
Total indexes: —
Avg fragmentation: —
Rebuild Needed
—
>30% fragmented
Reorg Needed
—
10–30% fragmented
Missing Indexes
—
query optimizer flagged
Unused Indexes
—
0 reads since restart
Healthy
—
<10% fragmented
Fragmentation
Missing Indexes
Unused Indexes
Duplicates
Fragmentation Analysis
| Table | Index Name | Type | Frag % | Pages | Row Count | Action |
|---|
Missing Index Recommendations
Ranked by estimated impact
| Table | Equality Cols | Include Cols | Impact Score | Seeks | Avg Cost Savings |
|---|
Unused Index Analysis
No reads since last SQL Server restart
| Table | Index Name | Size (MB) | User Reads | User Writes | Created | Recommendation |
|---|
Duplicate & Overlapping Indexes
Wasted space + write overhead
| Table | Index A | Index B | Overlap Type | Wasted MB | Action |
|---|