search

olahallengren / sql-server-maintenance-solution

SQL Server Maintenance Solution
https://ola.hallengren.com
MIT License
2.91k stars 756 forks source link

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

Open heng0136 opened 3 years ago

heng0136 commented 3 years ago

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.