Symptom
- WaitTime of WaitEventID = 780 is constantly growing every time you retrieve a result set from master..monProcessWaits. What does it mean ?
1> select * from master..monProcessWaits
2> go
SPID InstanceID KPID ServerUserID OrigServerUserID WaitEventID Waits WaitTime
----------- ---------- ----------- ------------ ---------------- ----------- ----------- -----------
1 0 327683 0 0 215 6 0
1 0 327683 0 0 780 6 130755
.....
1> select * from master..monProcessWaits
2> go
SPID InstanceID KPID ServerUserID OrigServerUserID WaitEventID Waits WaitTime
----------- ---------- ----------- ------------ ---------------- ----------- ----------- -----------
1 0 327683 0 0 215 15 0
1 0 327683 0 0 780 15 8151357
.....
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
SAP Adaptive Server Enterprise 16.0
Keywords
monSysWaits, 780, MEMORY TUNE , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.