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.