Guardian
Index analysis complete · 14 indexes need attention · Est. performance gain: +23% read throughput
Last scan: 4 min ago
Total indexes: 247
Avg fragmentation: 18.4%
Rebuild Needed
6
>30% fragmented
Reorg Needed
8
10–30% fragmented
Missing Indexes
11
query optimizer flagged
Unused Indexes
19
0 reads since restart
Healthy
203
<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 |
|---|