You administer a Microsoft SQL Server database.
Users report that a billing application is throwing errors during busy times of the day.
You identity that the following error is regularly written to the application’s error tog every day between 4:00 pm and 5:30 pm:
Error 1205: Transaction (Process ID) was deadlocked on resources with another process and Has been chosen as the deadlock victim.
You need to determine tike cause of deadlocks. You start a trace using SQL Server Profiler.
Which event should you select?
A . Lock: Timeout
B . Deadlock graph
C . Lode Escalation
D . Lock: Deadlock
Answer: D