3643647 - Slow performance with frequent very large transactions - SAP SRS

• Frequently vary large transaction on Primary database causes Backlog accumulated in OBQ.
  
  
• Large tran (50K+ rows in one transaction ) seen in OBQ is not moving or moving slowly.
  st:C,cmds:1477110,qid:585811:7:93 
  or
  st:R,cmds:1277110,qid:585811:7:93
  
  
• OBQ Max memory Consumed reaches to 80% of the Threshold  and DSIS Max memory consumed reaches to 80% of the Threshold.
  
  1> admin stats,mem_detail_stats
  2> go
   Object(State)  Memory_Consumed     Memory_Consumed_Mb  Max_Memory_Consumed_Mb   Avg_Memory_Consumed_Mb   Memory_Threshold_Mb Memory_Ctrl_Time(s)
  
   OBQ  (Norm)    30067057960               28674                                       28704                                28672                                    35836               0

            DSIS (Norm)     5560635552                5303                                         233449                                5319                                   291811              0

• SAP Adaptive Server Enterprise (ASE) 16.0 with Always On Option (HADR)
• SAP Replication Server (SRS) 16.0

KBA , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , Product Enhancement