Administering SQL Server
Locks Event Category
Use the Locks event category to monitor Microsoft® SQL Server™ lock activity. By monitoring the Locks event classes, you can investigate contention issues caused by users and applications using a database concurrently.
Because lock events are so prolific, capturing the lock event classes can incur significant overhead on the server being traced and result in very large trace files or trace tables.
