You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network contains a SQL Server 2005 database named Certkiller -DB03.
You have received several reports from users’ stating that they received deadlock error messages in an order processing application. You monitor which objects and SQL Server session IDs are involved when deadlock conditions occur. You want data regarding every participant in the deadlock.
What should you do?