Administering a SQL Database Infrastructure — Question 89

You administer a Microsoft SQL Server 2016 database.
Users report that a billing application becomes unresponsive during busy times of the day.
While investigating, you notice large number of processes taking or waiting for table locks.
You suspect that SQL Server is assigning stronger locks to queries.
You start a SQL Profiler trace.
Which event should you select?

Answer options

Correct answer: B

Explanation

The correct answer is B, Lock: Escalation, as it helps in monitoring when SQL Server escalates locks from row-level to table-level, which can lead to unresponsiveness during high load. Options A, C, and D focus on different aspects of locking and deadlocks, but do not specifically address the issue of lock escalation during busy periods.