• Daily maintenance rebuild if the fragmentation level > 30%, between 20 and 30% reorg

    updates stats with default algorithm.

    weekend schedule is if the fragmentation level between 1 and 2% reorg(in this case it reorg)

    >2% rebuild

    updates stats with full scan

    weekend doesn't have any threshold's I want to do index maintenance

    Yes the pk index is taking that long that's why I am trying to figure out what going on. the index in question is excluded from daily maintenance. Job will do perform only index optimization no DBCC checks, job is separate only for this table.

    client don't have maintenance until I set up. first week it ran fine, slowness noticed on second and third runs(yesterday - it take 22 hours to complete all indexes and stats)