SAP Knowledge Base Article - Preview

2946040 - COMMIT TRAN performance is slow - SAP ASE for Business Suite HADR

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 Enterprise Resource Planning (ERP) 6.0
    • 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 ONE Support launchpad (Login required).

    Search for additional results

    Visit SAP Support Portal's SAP Notes and KBA Search.