Five Reasons Why Your SQL Server Is Slow Right Now
In this video, I delve into the reasons why your SQL Server might be experiencing performance issues right now. Starting off a bit blurry, I quickly set up to ensure crisp and clear visuals for you, as I was recently voted by BeerGut Magazine as the most crisp SQL Server consultancy in the world-a nice change from past threats of legal action or assassination attempts! The key to diagnosing slow SQL Servers lies in having the right tools at your disposal. I emphasize the importance of using a remote DAC (Dedicated Administrative Connection) and useful scripts like SP Who is Active and SP Pressure Detector, which can help you understand exactly what's causing the slowdown without being impacted by ongoing issues. This video aims to gather all these troubleshooting tips in one place, as restarting SQL Server often clears out valuable diagnostic information, making it harder to pinpoint the exact cause of performance issues.
CHAPTERS
00:00:00 - Introduction
00:01:29 - SQL Server is Unhappy
00:02:50 - Restarting SQL Server
00:03:33 - Evidence in Other Places
00:04:48 - Additional Information
00:05:32 - Common Changes
00:06:23 - Surprise Stats Updates
00:07:10 - Five Most Common Issues
00:08:01 - Threads and Thread Pool Weights
00:09:07 - SQL Server Worker Threads
00:10:13 - Memory Pressure
00:12:06 - Resource Governor
━━━━━━━━━━━━━━━━━━━━━━━━━━
📚 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
━━━━━━━━━━━━━━━━━━━━━━━━━━