The Index Row Hits (Percent) alert provides the percentage of the density of an index as used by the SQL Query Optimizer to determine index effectiveness. A high density indicates the existence of many duplicates and an inefficient index. A low density indicates high selectivity and an effective index.

This alert is raised based on the database metrics collection interval specified in Server Properties.

This alert is for visual indicators in the Desktop Client only. SQL Diagnostic Manager does not send notification when this alert is triggered.

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >