[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Database slowness

[mboubidi]

> promon/R&D/1/16. Database Service Manager Free messages and total messages are same and not consumed. High water mark is 652 (what it indicates) and can you explain what we have monitor. Please find below information, Enter a number, , P, T, or X (? for help): 16 10/08/19 Status: Database Service Manager 12:12:03 Communication Area Size : 32768.00 KB Total Message Entries : 299592 Free Message Entries : 299592 Used Message Entries : 0 Used HighWater Mark : 652 Area Filled Count : 0 Service Latch Holder : -1 Access Count : 29945984 Access Collisions : 5534 Registered Database Service Objects Name Rdy Status Messages Locked by OpenEdge RDBMS Y REG 0 OpenEdge Replication Server Y RUN 0 Enter , R, P, T, or X (? for help): R 10/08/19 Status: Database Service Manager 12:13:03 Communication Area Size : 32768.00 KB Total Message Entries : 299592 Free Message Entries : 299592 Used Message Entries : 0 Used HighWater Mark : 652 Area Filled Count : 0 Service Latch Holder : -1 Access Count : 29948456 Access Collisions : 5534 Registered Database Service Objects Name Rdy Status Messages Locked by OpenEdge RDBMS Y REG 0 OpenEdge Replication Server Y RUN 0 Enter , R, P, T, or X (? for help): R 10/08/19 Status: Database Service Manager 12:13:05 Communication Area Size : 32768.00 KB Total Message Entries : 299592 Free Message Entries : 299592 Used Message Entries : 0 Used HighWater Mark : 652 Area Filled Count : 0 Service Latch Holder : -1 Access Count : 29948507 Access Collisions : 5534 Registered Database Service Objects Name Rdy Status Messages Locked by OpenEdge RDBMS Y REG 0 OpenEdge Replication Server Y RUN 0 Enter , R, P, T, or X (? for help): R 10/08/19 Status: Database Service Manager 12:13:08 Communication Area Size : 32768.00 KB Total Message Entries : 299592 Free Message Entries : 299592 Used Message Entries : 0 Used HighWater Mark : 652 Area Filled Count : 0 Service Latch Holder : -1 Access Count : 29948641 Access Collisions : 5534 Registered Database Service Objects Name Rdy Status Messages Locked by OpenEdge RDBMS Y REG 0 OpenEdge Replication Server Y RUN 0 Enter , R, P, T, or X (? for help): R 10/08/19 Status: Database Service Manager 12:13:09 Communication Area Size : 32768.00 KB Total Message Entries : 299592 Free Message Entries : 299592 Used Message Entries : 0 Used HighWater Mark : 652 Area Filled Count : 0 Service Latch Holder : -1 Access Count : 29948748 Access Collisions : 5534 Registered Database Service Objects Name Rdy Status Messages Locked by OpenEdge RDBMS Y REG 0 OpenEdge Replication Server Y RUN 0 Enter , R, P, T, or X (? for help): R 10/08/19 Status: Database Service Manager 12:13:15 Communication Area Size : 32768.00 KB Total Message Entries : 299592 Free Message Entries : 299592 Used Message Entries : 0 Used HighWater Mark : 652 Area Filled Count : 0 Service Latch Holder : -1 Access Count : 29948937 Access Collisions : 5534 Registered Database Service Objects Name Rdy Status Messages Locked by OpenEdge RDBMS Y REG 0 OpenEdge Replication Server Y RUN 0

Continue reading...