SAP Knowledge Base Article - Preview

3052872 - Server using SSL connections has performance issues - SAP ASE

Symptom

  • When running a single session a query takes 11 seconds
  • When running 100's of parallel sessions the same queries take over an hour.
  • There are no errors in the ASE log - and no blocking on the queries.
  • Running a query on the MDA table, monSysWaits and  WaitEventID=657 shows an increase in waitTime:

    WaitEventID  WaitTime     Waits
                657        2273          11
                657        2474          12
                657        2657          14
                657        2662          14
                657        2857          15
                657        3043          17
                657        3247          18
                657        3447          19
                657        3478          20
                657        3648          21
                657        3849          23
                657        4037          24
                657        4211          25
                657        4239          25
                657        4447          27
                657        4637          28


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

    Product

    SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.0 Cluster Edition

    Keywords

    KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

    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.