Sybase Memory Structures Layer

This layer monitors wait events and the locking activity on the database server to identify areas where the server has been wasting resources.  Using the tests mapped to this layer, administrators can quickly isolate the following:

• Wait events on which the server has spent the maximum time; who and which process initiated such an event;
• Deadlock situations;
• Locks that have been held for too long a time; who and which process initiated the lock, and which object held the lock for how long.

Figure 1 : The tests associated with the Sybase Memory Structures layer