SAP Knowledge Base Article - Preview

2947040 - WaitTime of WaitEventID = 780 in monProcessWaits is constantly growing - SAP ASE

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.