Sign in to confirm you’re not a bot
This helps protect our community. Learn more

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

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
2.3K views 2 years ago
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 ...more
...more
Waiting due to deadlocks [6 of 7] | Azure SQL for beginners
39Likes
2,358Views
2023Feb 8
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

Follow along using the transcript.

Microsoft Developer

588K subscribers