SentryOne Index Analysis is a capability that presents actionable information to help you make smart decisions about SQL Server index management, which can help speed performance of your databases.
The Indexes tab in the Performance Analysis Dashboard displays information about your tables and indexes that are collected by the SentryOne Fragmentation Manager.
This tab provides the stats you need to make informed decisions about index management in your SQL Server environment as you determine whether an index should be rebuilt or defragmented with the Fragmentation Manager.
The Indexes tab also displays a set of charts that contain aggregated statistics about the indexes that have been analyzed. You can also see index-related statistics such as the average percentage of fragmentation.
The SentryOne Indexes tab helps you make good decisions about index management in your SQL Server environment, including when and how to perform defragmentation operations, when to adjust fill factors, or when an index definition should be changed.
You can also look at a tree view of indexes and related metrics as well as view detailed charts for a selected index to look at fragmentation history and more.
Want to proactively manage defragmentation? With the SentryOne Fragmentation Manager, you can set an automated scheduled for index defragmentation.
The Indexes tab in SentryOne gives you all the relevant metrics you need to make informed decisions about index management—and boost SQL Server performance.
The SentryOne Total Fragmentation chart displays a once a day aggregation of the fragmentation levels for all indexes that have been analyzed by Fragmentation Manager.
Read more independent SentryOne reviews on TrustRadius.