search

olahallengren / sql-server-maintenance-solution

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

Persist_sample_percent - option to statistics maintenance #624

Open vesatikkanen opened 2 years ago

vesatikkanen commented 2 years ago

Hi,

First: Thank you very much for your script they are just awesome.

I have a suggestion for feature that I think does not exists. Also I tried to look if someone has already asked that and could not find that. I'm sorry if this is a duplicate of already existing request.

SQL Server has a feature for setting auto update statistics threshold to something else than default. Would be good if this setting could also be set when running your scripts.

https://support.microsoft.com/en-us/topic/kb4039284-enhancement-new-keyword-is-added-to-create-and-update-statistics-statements-to-persist-sampling-rate-for-future-statistics-updates-in-sql-server-55871e7f-d4eb-e4f1-d7c5-2e7ba3985c9c

If you want I can create a pull request with that feature implemented if you want.

MarioPalomba commented 2 years ago

Hi Vesa, just few days ago i asked to Ola if he could implement the persist_sample_percent parameter in his mantainance script. I hadn't notice your open issue. It will be great to take a look to your version of mantainence script. Thanks in advance. Bye.