From the SQL command line you can use the ALTER SYSTEM CREATE WAITGRAPH command to create a waitgraph file that contains thread information about deadlocks.
SQLServer automatically logs all deadlocks. Can anyone help me to get sql query which will capture deadlocks data that is being collected, for a recent event.
Learn how you can detect & resolve SQL deadlocks in SQL servers. Learn about the different types of SQL server deadlocks, how they happen & how to fix them.
A SQL deadlock detecting tool like SolarWinds SQL Sentry enables you to quickly recognize when a deadlock has occurred, understand its root causes, and see ...