sql-server-maintenance-solution
sql-server-maintenance-solution copied to clipboard
Add a job that only updates statistics
Add a job that updates statistics without doing index maintenance I publish a script that creates a job to do this here: https://github.com/erikdarlingdata/DarlingData/tree/main/OlaStatsOnly
I think it would be good for something similar to be distributed with your scripts, though, since index maintenance has diminishing utility in a non-rotational storage world. Your repo has far greater reach than mine.
Modified jobs and prepared my Zabbix monitoring with looking for UpdateStatistics - USER_DATABASES so glad if you decide to go with that name 😃