Monitor Locks and Deadlocks
Use the sp_iqlocks stored procedure to display details about
row-locks, write-intent locks, and deadlocks in the database.
- Tutorial: Monitoring Write-Intent Locks
In this tutorial, create RLV-enabled tables, execute a transaction, and use the sp_iqlocks stored procedure to report on schema-level locks and write-intent locks in the database. Then use the sp_iqconnection and sa_conn_info stored procedures to view the internal connection controlling the write-intent lock.
- Tutorial: Monitoring Row-Level Locks
In this tutorial, create RLV-enabled tables, commit a transaction, and delete the committed row to show row locking, and row-range locking. The sp_iqlocks stored procedure reports on the row-level locks.
- Tutorial: Monitoring Deadlocks
In this tutorial, add deadlocks to the RLV store, log the deadlocks for reporting purposes, and report deadlock information using sa_report_deadlocks.
- Creating a Deadlock Reporting Event in Interactive SQL
Create a table and a system event for obtaining information about deadlocks.
Created December 19, 2013. Send feedback on this help topic to Technical Publications:
pubs@sap.com