If you are experiencing deadlocks in SQL Server, you want to know more about them. What queries are causing them? What tables and indexes are at the root of the problem? You can find this information by using tools such as trace flags, Profiler, and Extended Events.
[youtube SWiAPZiXbyg]
Video producer: http://www.brentozar.com/