After searching in different sites and QnAs, i am so confused on how i can:
- Find Deadlocks and what time they occured
- How to identify what happened and a deadlock arrised.
- And what is the query that caused a deadlock.
Is there any Query to extract such information?
Note that i have seen the tables
and still i do not understand.