Open erikdarlingdata opened 2 years ago
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 😃
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.