...

Summary

The Content Server has a high Average Request Time. All Request are Very Slow. Usualy the Thread count going upEs wird überprüft ob eine URL die mit dem Monitoring Agent überwacht nicht einen Status 200 zurückgibt.

Sources of Errors

1. Database Locks of Tables

   1. Oracle Database

      1. Select for Database Lock

         Code Block
         select (select username from v$session where sid=a.sid) blocker, a.sid, ' is blocking ', (select username from v$session where sid=b.sid) blockee, b.sid from v$lock a, v$lock b where a.block = 1 and b.request > 0 and a.id1 = b.id1 and a.id2 = b.id2;

      2. Solution: → Contact your DB Admin he can Remove the Lock.

   2. SQL

      1. SQL Server Locks, Blocked Processes, and Two Easy Ways to Find Them | Diagram (wearediagram.com)

2. To many request from the Clients

   1. Waiting Waiting…

...