Symptom
On an SAP ASE HADR system with Rep Agent in SYNC mode:
- COMMIT TRAN spids take a long time to complete and accumulate. They also block other spids over time.
- DBACockpit -> Wait Events reports a very high number of waits for WaitEventIDs 712 and 713,
712 - User task waits on commit for sync rep acknowledgement
713 - User task waits on commit for sync rep acknowledgement or timeout - The stacktrace for the COMMIT TRAN spid collected via "dbcc stacktrace (spid)" in isql, references the function: ra_ci_sync_sleep()
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP NetWeaver (NW) - All versions
- SAP Enterprise Resource Planning (ERP) 6.0
- High Availability Disaster Recovery (HADR)
- SAP Replication Server (SRS) 16.0
Product
SAP ERP 6.0
Keywords
CR#821864, CR821864, 821864, "COMMIT TRAN", HADR, SRS, performance, slow , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.