Which event should you select?

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

View Answer

Answer: D