PRB: Index Tuning Wizard Does Not Suggest Proper Index When There Is Not Enough Space

When you use the Microsoft SQL Query Analyzer query selection functionality of the Index Tuning Wizard (ITW), the ITW may not recommend an appropriate index.

If the index requires more space than what is displayed in the Index Tuning parameters, the ITW does not recommend an index.

The Maximum space for the recommended indexes (MB) option is located under the Advanced Options tab in the Index Tuning Wizard.

NOTE: The Maximum space for the recommended indexes (MB) option specifies the maximum space in megabytes that can be consumed by the recommended index set. The default space is three times the current data size or the maximum available space on all attached disk drives, whichever is smaller.

If you suspect that this may be an issue, increase the value in the Maximum space for the recommended indexes (MB) option.