Here is another popular lab from Hands-On-Lab library: SQL Server Deadlock Basics.
A deadlock occurs when two or more sessions permanently block each other with each session having a lock on a resource, the other session is trying to lock. This lab is divided into 4 exercises explaining different dead lock scenarios. In the first exercise we will learn about deadlocks, second exercise will talk about deadlock detection, third exercise will explain about deadlock graph and the final exercise will talk about deadlock XML.
Exercise 1: Introduction to Deadlocks
Exercise 2: Deadlock Detection
Exercise 3: Understanding Deadlock Graph
Exercise 4: Understanding Deadlock XML
SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.
Happy Learning – The Practical Way.