How to monitor deadlock using extended events in SQL Server 2008 and later

Before I talk about how to monitor the deadlocks let us have a small brief what is deadlock and how we were handling them in the previous versions of SQL Server.   Deadlock: A deadlock occurs when there is a cyclic dependency between two or more threads, or processes, for some set of resources within…

9

SQL Server Deadlocks Due to Character Data Type Conversion When Using SQL Server JDBC drivers

Recently, I worked on a case with one of my clients wherein SQL Server was encountering several deadlocks when they were running Stress Tests from application. They had tried several techniques to resolve this issue including forcing an index on the query, disable lock escalations and setting the database in Snapshot Isolation level. But nothing…

3