Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
After searching in different sites and QnAs, i am so confused on how i can:
Is there any Query to extract such information?
Note that i have seen the tables
sys.dm_tran_locks
sys.dm_exec_requests
and still i do not understand.
A good way to find the deadlocks which have happened is with the use of the First Responder Kit from Brent Ozar.
This can be found here: https://www.brentozar.com/first-aid/
When installed, you can run the sp_blitzlock command and see deadlock information.
Another option, is to look in the ring buffer Martin suggested: https://www.sqlshack.com/monitoring-sql-server-deadlocks-using-the-system_health-extended-event/#:~:text=system_health%20event%20session.-,Extract%20SQL%20Server%20Deadlock%20information%20using%20T%2DSQL%20from%20the%20ring%20buffer%20target,-We%20can%20use
