Solution : https://service.sap.com/sap/support/notes/806342 (SAP Service marketplace login required)
Summary :
SAP Note addresses the issue of exclusive lockwaits and deadlocks in SAP environments. Exclusive lockwaits occur when a process requests to lock a database object exclusively but is blocked by another ongoing transaction. This results in delays and can severely impact system performance by reducing parallelism and causing application timeouts. Deadlocks happen when two processes each hold a lock the other needs, creating a standstill. The note provides monitoring and resolution strategies using transactions like SM66 and DB01, and tools like ‘Blocking lockstats’ and ‘Hangman’. Recommendations include detailed analysis to identify and resolve blocking locks to optimize database and application performance.
Key words :
spid blocked waittime lastwaittype waitresource status cmd---- ------- -------- -------------- ------------ -------- ------74 74 0 pageiolatch_ex 7, calling transaction st04 -> detail analysis menu -> blocking lockstats, st04 -> detail analysis menu -> excluding lockwaits, 'detail analysis menu' button -> blocking lockstats, call transaction st04 -> click, 'wait type' columns describe, sap ccms cleanup saplocks, sysjobs set originating_server = 'rightservername', 'blocking lockstats' monitor return, sap ccms blocking lockstats
Related Notes :
| 1152848 | FAQ: SQL Server Wait Events |