Deadlocks go bump in the night, and they’re kinda mysterious. Your monitoring app or developers might have been warning you about them, but nobody’s really sure what to do about ’em, or what code to look at. We’ll use sp_BlitzLock for analysis help to figure out what queries & tables need to be changed. In…
05 Analyzing Deadlocks with sp_BlitzLock
Deadlocks go bump in the night, and they’re kinda mysterious. Your monitoring app or developers might have been warning you about them, but nobody’s really sure what to do about ’em, or what code to look at. We’ll use sp_BlitzLock for analysis help to figure out what queries & tables need to be changed. In…
To access this incredible, amazing content, you gotta get Recorded Class Season Pass or How I Use the First Responder Kit, or log in if you already shelled out the cash.
- 00 Prerequisites Before the Class
- 01 Doing a Server-Wide Health Check with sp_Blitz
- 02 Doing a Server-Wide Performance Check with sp_BlitzFirst
- 03 Using sp_BlitzCache to Find the Queries Causing Your Top Waits
- 04 Using sp_BlitzIndex to Diagnose the Most Urgent Index Issues
- 06 Check Which Queries Are Running with sp_BlitzWho and sp_WhoIsActive
- 07 Check Your Data Risks with sp_BlitzBackup
- 08 Automate the Data-Gathering Process with the Consultant Toolkit
- 09 Recap and Writing Up Your Findings