Waiting due to deadlocks [6 of 7] | Azure SQL for beginners

In this episode we will look at another common performance problem due to deadlocks between SQL users. This scenario involves a problem where little, or no CPU is observed but no long blocking problem is seen. We will look at the symptoms of a problem due to deadlocks, common causes, and solutions on how to prevent them.

0:00 Introduction
0:58 What is a deadlock?
2:00 Using Azure Diagnostics and Kusto (KQL)
2:44 The troubleshooting process
3:37 Demo
8:08 Avoiding and handling deadlocks
9:22 Summary
9:55 Learn more

Resources:
For the full Azure SQL for beginners Special Edition series on Performance Troubleshooting, watch: https://aka.ms/performanceseries
For the full Azure SQL for beginners series, watch: https://aka.ms/azuresql4beginners
Learn more about SQL deadlocks: https://aka.ms/sqldeadlocks
Azure SQL Workshop​: https://aka.ms/azuresqlworkshop
Azure SQL Fundamentals​: https://aka.ms/azuresqlfundamentals
Watch Data Exposed​: https://aka.ms/dataexposed
See more videos from our team​: https://aka.ms/azuresqlyt
Follow us on social media​: https://aka.ms/azuresqltwitter
Read the books: https://aka.ms/azuresqlbook, https://aka.ms/azuresqlfordevelopers

Видео Waiting due to deadlocks [6 of 7] | Azure SQL for beginners канала Microsoft Developer