search

microsoft / tigertoolbox

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

Suggestion - Update Statistics Only #254

Open lordcookies87 opened 3 years ago

lordcookies87 commented 3 years ago

Right now, it is not possible to update statistics only, without also defragging indexes.

kdefilip commented 3 years ago

Hi Thanks for your response. Yes, I understand there is no "stats only" option. However, when I force a defrag on a few problematic tables by using a job with very low frag rate in the Adaptive Defrag (ADf) settings, no stats are updating upon completion of the defrag, regardless of the ADf settings I have tested to force a stats update post-defrag. My problem is that I have a few large tables (8-14 mil rows) and once the change rate reaches about .03 percent, queries against those tables completely tank. I need sample rates on these tables of at least 10 percent on these tables to correct this issue. No matter what settings I have attempted, I can not get the stats to update using ADf post-defrag. Or when they do update, they fall back to the MS algorithm and I end up with a sample rate of .002 percent.

On Thu, Aug 26, 2021 at 1:23 PM lordcookies87 @.***> wrote:

Right now, it is not possible to update statistics only, without also defragging indexes.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/microsoft/tigertoolbox/issues/254, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADMX4RFLM57B7MEWPYYSZPDT6Z2CZANCNFSM5C32K2RQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&utm_campaign=notification-email .