
9. Index Analysis
If you have Fragmentation Manager, then you will have access to advanced tools to help manage your
index fragmentation. You have the ability to perform automated defragmentation operations based on a
schedule you set and the ability to enable post defragmentation analysis operations. You also have the
ability to initiate manual defragmentation operations from the SQL Sentry Client. Fragmentation Manager
also gives you access to historical information about index fragmentation in your environment including
historical charts, which summarize both detail level and overview level fragmentation statistics.
You also have 2 different ways to view all of the important statistics for your indexes. The first way is the
Grid View, which allows you to view index related statistics in a tabular format. It shows statistics about
your individual indexes, including size, average percent fragmented, average percent page space used,
fill factor, and much more.
Comentarios a estos manuales