Export (0) Print
Expand All

Locks Event Category

SQL Server 2000

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.

See Also

Locks Event Classes

Locks Data Columns

© 2015 Microsoft