May 1, 2024 at 4:04 pm
We have pretty big tables very sensitive to stats with many updates.
Our systems are complex with many places requiring explicit statistics updates and we want to monitor this to investigate potential SAMPLE updates overwriting FULLSCAN updates.
We managed to catch all such updates through extended events by filtering on sp_statement_starting and sql_statement_starting but we are wondering about AUTO updates.
can we monitor these as well?
May 1, 2024 at 4:24 pm
there is an Auto_Stats ext event under the execution category, track the incremental and sample_percentage columns
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 3, 2024 at 2:32 pm
Yep. What Perry says. Also, test enabling causality tracking to be able to correlate queries to the stats updates.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply