Loading...

Health Report - Database Index Fragmentation

This report lists the number of fragmented indexes in each database in the CommCell environment and indicates the overall status of the database.

To view this report:

  • In the Health Report, in the Scale Statistics table, next to Database Index Fragmentation, click View Details.

Databases

This table lists each database in the CommCell environment, the number of fragmented index in each database, and the status of the database.

Column Description
Database Name of the database.
Total Indices Total number of indexes in the database.
30% to 60% Fragmented Indices Number of indexes in the database that are 30% to 60% fragmented. Click on the value in this column to view the Database - Name Report.
60% to 100% Fragmented Indices Number of indexes in the database that are 60% to 100% fragmented. Click on the value in this column to view the Database - Name Report.
Status Overall status of the database based on the number of fragmented databases.To view the parameters for the different status types, click on any value in the Status column. For instructions, see View Health Report Parameters.

Database - Name

This table lists each index in the database, the number of fragmented index in each database, and the status of the database. To view this table, in the Database table, click a value in the 30% to 60% Fragmented Indices or 60% to 100% Fragmented Indices column.

Column Description
Database Name of the database.
Table Name of the table.
Index Name of the index.
Index Type Type of index.
Average Fragmentation Percent Percentage of index that is fragemented.