sql-server-maintenance-solution icon indicating copy to clipboard operation
sql-server-maintenance-solution copied to clipboard

Disabling auto-update stats on mentioned DBs when executing DB maintenances and enable back once done

Open heng0136 opened this issue 4 years ago • 0 comments

Description of the feature To temporarily disable auto-update stats of mentioned DBs before it starts the maintenance, and then enable back auto-update stats when it's done.

Reasons On a busy OLTP databases, the in-built auto-update stats feature will become very hardworking, and this sometimes resulted in blocking between the DB maintenance and auto-update stats. Therefore, being able to disable that busy OLTP DB will allow the DB maintenance to go smoothly.

heng0136 avatar Aug 10 '21 09:08 heng0136