PrepAway - Latest Free Exam Questions & Answers

Tag: sql server detect page level lock

Which event should you trace?

You are the database administrator for a banking company. You manage all the SQL Server 2008 databases ofthe company.
The company stores customer-related data in the database named Cust01. This database isaccessed by most users in the company for different purposes.
The users daily perform insert and updates to the database through a .NET application.
Eric, a user in the database, complains that his transaction has frozen and that he is not able to perform anyoperation in the database.
You find out that the problem is due to a deadlock.
You want to find out the user who isthe other participant in the deadlock by using SQL Server Profiler.
Which event should you trace?