IndexOptimize - Feature to estimate duration for completing index or statistics operations if a time limit is set and skip if exceeds #653

siweston · 2022-06-23T11:35:38Z

If a time limit has been set some indexes or statistics operations could end up running over due to the size and how close to the end of the window the operation starts.

Using the data collected in the CommandLog table we could use this to estimate how long the operation may take and skip processing the object if it exceeds the time limit.

This feature is aimed at SQL < 2017 as the MAX_DURATION setting is available.

@indexes

…ate Command Duration Update IndexOptimize - Add @TimeLimitEstimateCommandDuration (options: Min,Avg,Max) - Estimate duration of index and statistics commands for an object - skipping if the current time + duration exceeds the time limit. Also remove TimeLimit check around listing indexes in current database otherwise you receive error 'The following objects in the @indexes parameter do not exist' running when exceeded time limit

olahallengren added IndexOptimize Feature Request labels Nov 2, 2024

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

IndexOptimize - Feature to estimate duration for completing index or statistics operations if a time limit is set and skip if exceeds #653

IndexOptimize - Feature to estimate duration for completing index or statistics operations if a time limit is set and skip if exceeds #653

siweston commented Jun 23, 2022

IndexOptimize - Feature to estimate duration for completing index or statistics operations if a time limit is set and skip if exceeds #653

IndexOptimize - Feature to estimate duration for completing index or statistics operations if a time limit is set and skip if exceeds #653

Comments

siweston commented Jun 23, 2022