tigertoolbox icon indicating copy to clipboard operation
tigertoolbox copied to clipboard

AdaptiveDefrag @statsThreshold having no impact

Open kdefilip opened this issue 4 years ago • 1 comments

Using @statsThreshold to force a sample rate on a table seems to have no impact on sample rate. For example using @statsThreshold = 30 on individual tables still results in very low sample rate as determined by MS sample algorithm. Am I missing something here?

kdefilip avatar Jul 17 '21 11:07 kdefilip

After extensive testing, I've come to the conclusion that AdaptiveIndexDefrag does not work as advertised.

kdefilip avatar Aug 21 '21 11:08 kdefilip