Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.
on April 20, 2017
An important query is suddenly slow. Is it because statistics are out of date? This is tricky to figure out, and updating statistics right away can make troubleshooting even harder. Learn how to use query execution plans to get to the heart of the question and find out if stats are really your problem, or if it’s something else.
In this 35 minute episode:
- 00:39 SQL Server 2017 Announced
- 01:10 New video from Microsoft’s Joe Sack demonstrating Adaptive Query Processing
- 03:05 This week’s question: Are bad stats making my query slow?
- 05:26 Demo of finding plan in cache and analyzing stats begins
- 28:17 What to do when stats ARE the problem
Code samples are at the bottom of the page
Audio-only version (downloadable)
Head to the episode home page for this
Video version
Related links
SQL Server 2017 Adaptive Query Processing video by Joe Sack
Michael J Swart on finding Dark Matter Queries
Slow in the Application, Fast in SSMS? An SQL text by Erland Sommarskog