- Analyze fragmentation by one table or an entire database
- Identify databases in need of defragmentation
- Set fragmentation thresholds: normal, warning, critical
An easy to view graphical representation of fragmentation levels across your SQL Servers shows index type, fragmentation percentages, size and fill-factor so users can spot immediately what given area needs attention.
With SQL fragmentation analyzer’s color coded graph, quickly identify the databases containing the highest fragmentation levels. View fragmentation levels for an entire database or a specific table.
Determine and set thresholds for fragmentation levels including what levels to consider unacceptable. Specify normal, warning, and critical levels based upon our recommendations or implement your own best practices.