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?
A.
You need to trace the Lock:Deadlock event by making use of the SQL Server Profiler.
B.
You need to trace the Lock:Timeout event on Certkiller -DB03 by making use of the SQL Server Profile.
C.
You need to trace the Lock:Deadlock Chain event on Certkiller -DB03 by using the SQL Server Profiler.
D.
You needs to trace the SQLServer:Locks – Number of Deadlocks/sec counter on Certkiller -DB03 by using System Monitor.
Explanation:
Use SQL Server Profiler to identify the cause of a deadlock. A deadlock occurs when there is a cyclic dependency between two or more threads or processes for some set of resources within SQL Server. Using SQL Server Profiler, you can create a trace that records, replays and displays deadlock events for analysis.