You are a database administrator for your company managing all your company’s SQL Server 2008 databases.
The Prod_details database is the main database accessed by users in the company. The head office of thecompany receives data from other branches.
After the employees of the audit department have verified the data,the database is updated with the data.
Some employees in the audit department complain that either the update process is very slow, or timeout errormessages are displayed when they try to update the data in the database.
You suspect concurrency issues to bethe cause of the problem and decide to monitor the transaction locks held on the database objects by using theSQL Server Profiler.
Which event should you monitor in the SQL Server Profiler?