How to Monitor Deadlocks in Azure SQL Managed Instance
Tales From The Field
View ChannelAbout
https://www.youtube.com/@Tales-from-the-Field?sub_confirmation=1 Welcome to Tales from the Field! This channel features Bradley Ball aka @SQLBalls, Andres Padillia, Josh Luedeman, Neeraj Jhaveri, Daniel Taylor aka @DBABulldog, & Brad Schacht. We all work for Microsoft, but this channel is not affiliated with Microsoft and any opinions expressed on the show are ours and ours alone, and not those necessarily of Microsoft. Our goal is to help educate you based on our customer experiences "in the Field". We present videos with helpful insights that we share with customers to solve real world problems. We hope you enjoy what we produce!
Latest Posts
Video Description
Bradley Ball aka @SQLBalls answers the question what is a Deadlock and what are the two ways I can monitor this in Azure SQL Managed Instance. SQL Server Profiler https://learn.microsoft.com/en-us/sql/tools/sql-server-profiler/sql-server-profiler?view=sql-server-ver16 Extended Events overview https://learn.microsoft.com/en-us/sql/relational-databases/extended-events/extended-events?view=sql-server-ver16 Quickstart: Extended events in SQL Server https://learn.microsoft.com/en-us/sql/relational-databases/extended-events/quick-start-extended-events-in-sql-server?view=sql-server-ver16 Use the system_health Session https://learn.microsoft.com/en-us/sql/relational-databases/extended-events/use-the-system-health-session?view=sql-server-ver16 Chapters 00:00 Introduction 00:57 What is a Deadlock 03:13 Demo - Creating the tables 03:58 Demo - Using Profiler 05:06 Demo - Trigger simple deadlock 05:56 Demo - Deadlock Graph in Profiler 06:40 Demo - system_health Extended Event 07:07 Demo - Trigger simple deadlock 07:39 Demo - turn XML output into a deadlock graph 08:18 Wrap up
No Recommendations Found
No products were found for the selected channel.