Скачать с ютуб What To Do When SQL Server is Slow Brent Ozar в хорошем качестве

What To Do When SQL Server is Slow Brent Ozar

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. Links to PASS and our Site: PASS: Pass.org DBAFundamentals: https://fundamentals.pass.org/default... Why to Go:    • Why Go to PASS Summit?   Use our discount code VGDISM843 to save $150.00 off the full price of PASS Registration can be completed here: https://www.pass.org/summit/2019/Regi...