2607913 - HVAR/RTL Performance Slow to SAP IQ - SRS

• Outbound queue is slow.

• Queue dump output shows too many rs_ticket entries sent from the primary database (PDB):
    

• QUEUE DUMP FOR 393:0
  BLOCK BEGIN q_number=393 q_type=0 blk=3888797:48 cnt=7
  ENTRY ver=1100 len=388 orig=168 lorig=0 oqid=00150015057d610300b06bc0000200b06bbf000f0000a887008608e60000000000000002 lqid=3888797:48:0 st=0 tr= '0015001505' }` 'f7000f' BHLINXeli '000000a800000000' comlen=261 rs_ticket 'V=2;H1=DBGSYB;H2=302182731;H3=-21600;H4=BHLINX;PDB(pdb)=02/14/18 08:08:01.286;EXEC(336)=02/14/18 08:08:01.295;B(336)=332829068911;DIST(189)=02/14/18 08:08:01.374;RSI(99)=02/14/18 08:08:01.617;RSI_B=425762062186;PRS=RS1'

  ENTRY ver=1100 len=188 orig=168 lorig=0 oqid=00150015057d610300b06bc0000200b06bbf000f0000a887008608e60000000000000003 lqid=3888797:48:1 st=1 tr= '0015001505' }` 'f7000f' BHLINXeli '000000a800000000' comlen=63 commit transaction
  
  --after 2 seconds --

  comlen=261 rs_ticket 'V=2;H1=DBGSYB;H2=302182731;H3=-21600;H4=BHLINX;PDB(pdb)=02/14/18 08:08:03.186;EXEC(336)=02/14/18 08:08:03.205;B(336)=332829142689;DIST(189)=02/14/18 08:08:03.401;RSI(99)=02/14/18 08:08:03.644;RSI_B=425762129535;PRS=RS1'

  ENTRY ver=1100 len=188 orig=168 lorig=0 oqid=00150015057d625700b06bd6000200b06bd500080000a88700860b3e0000000000000003 lqid=3888797:55:2 st=1 tr= '0015001505' }bN '000f' BHLINXeli '000000a800000000' comlen=63 commit transaction

• SAP Replication Server (SAP) 15.7.1
• SAP Replication Server (SAP) 16.0
• SAP Replication Server Real Time Loading (RTL) 15.7.1
• SAP Replication Server Real Time Loading (RTL) 16.0

IQ; RTL; HVAR; Latency; grouping; rs_ticket; CR 813577 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Product Enhancement