Project DescriptionSmart 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?