SMP Diag Index check for Fill Factor and Disabled indexes

book

Article ID: 158075

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

Indexes are a key aspect of the Notification Server performance.  Having disabled indexes can largely impact the performance in a negative way.

The Fill Factor of an index can affect performance as well.  Typically no fill factor should be defined however there are several tables that do have it defined out of the box.

Resolution

Enable any disabled indexes and change the Fill Factor of the indexes if it differs from a standard installation and no data is present to warrant the change.