Project Description
Smart Index Management is a new way to do index management, where the maintenance window constraints prevents managing all indexes every week.

Goal of Project is to deal with following issues:

• Rolling window maintenance
• Full scan then maintenance
• Can’t dynamically adjust MAXDOP
• Operation type (rebuild vs reorganize)
• Online vs offline
• Transaction log space monitoring
• Maintenance window constraint
• How quickly do my index become fragmented?
• What should be fill factor be?