This article will explore the process to capture deadlock XML and deadlock graphs for AWS RDS SQL Server databases.

Introduction

As a database professional, you confront the performance issues with databases. It might be due to a lack of indexes, improper indexes, poorly written T-SQL statements, outdated statistics, blocking, or deadlocks. It is essential to monitor the deadlocks in a SQL database irrespective of hosting on-premises or Cloud infrastructure.

Usually, we receive the following error in an application if SQL Server kills a process as the deadlock victim.

#aws #aws rds #deadlocks #aws rds #sql server