The DBA Fundamentals VG offers training and support to individuals interested in a solid DBA foundation.

Event Display
Meeting Detail

Tue, Mar 20 2018 16:30 UTC


What To Do When SQL Server is Slow - Brent Ozar

RSVP: None

What To Do When SQL Server is Slow

Someone comes running in and asks, "Are you doing something on the SQL Server right now? Can you take a look at it? It seems really slow." It's one of the most common complaints we get about our databases - and yet, most of us don't have a written plan with what steps to take, in order. I do this for a living, so I've had to make a written checklist to handle it. I'll give you the exact same checklist I use, then walk you through several performance emergencies. I'll show you how I use open source scripts like sp_WhoIsActive, sp_BlitzFirst, sp_BlitzCache, and more to find the root cause fast. We won't cover performance tuning - our goal in this hour is just to have a written triage process so we don't look like bumbling idiots. Let's get good at this! Bio: Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz and the SQL Server First Responder Kit, and he loves sharing knowledge at BrentOzar.com.


Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz and the SQL Server First Responder Kit. He loves sharing knowledge at BrentOzar.com.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids