The Unpredictability Of SQL Server Performance
In this video, I delve into the unpredictable nature of SQL Server performance issues, sharing a real-world client emergency that occurred on a Saturday afternoon. I discuss how slight changes in data and workload can significantly impact query plans and execution strategies, leading to unexpected performance fluctuations. By examining two simple queries with minor differences, I illustrate how subtle variations in literal values or statistics sampling can result in vastly different query plan choices, affecting performance by minutes. This video is a testament to the complexities of SQL Server maintenance and optimization, highlighting the importance of thorough index management and consistent data sampling for stable performance. If you're dealing with similar issues or need assistance optimizing your SQL environment, I'm here to help-just like I did on that busy Saturday.
CHAPTERS
00:00:00 - Introduction
00:00:29 - Client Emergency Context
00:00:59 - SQL Server Stability Issues
00:01:10 - Data Changes and Adjustments
00:01:53 - Query Plan Differences
00:02:19 - Clustered Index Scan vs Key Lookup
00:02:48 - Green Text Index Explanation
00:03:17 - Modification Queries Need Indexes
00:03:53 - Statistic Sampling Impact
00:04:34 - Resampled Statistics Effect
00:04:57 - Query Plan Stability Challenges
00:05:36 - Locking Strategies Variability
00:06:38 - Oddball Performance Problems
00:07:36 - SQL Server Performance Coaching
00:08:02 - Ready to Help with Solutions
00:08:14 - Martini Time
00:08:45 - New Haircut Announcement
━━━━━━━━━━━━━━━━━━━━━━━━━━
📚 TRAINING & COURSES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Get AI-Ready With Erik
https://training.erikdarling.com/get-...
SQL Server Performance Engineering Course
https://training.erikdarling.com/sql-...
Learn T-SQL with Erik
https://training.erikdarling.com/lear...
Everything Bundle:
https://training.erikdarling.com/?cou...
━━━━━━━━━━━━━━━━━━━━━━━━━━
🛠️ CONSULTING & SERVICES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Need SQL Server performance help?
https://training.erikdarling.com/sqlc...
━━━━━━━━━━━━━━━━━━━━━━━━━━
💬 CONNECT
━━━━━━━━━━━━━━━━━━━━━━━━━━
Ask questions at Office Hours
https://erikdarling.com/officehours/
Become a channel member
/ @erikdarlingdata
━━━━━━━━━━━━━━━━━━━━━━━━━━