search

microsoft / tigertoolbox

Toolbox repository for Tiger team
http://aka.ms/sqlserverteam
Other
1.45k stars 734 forks source link

AdaptiveDefrag @statsThreshold having no impact #249

Open kdefilip opened 3 years ago

kdefilip commented 3 years ago

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 commented 2 years ago

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