Page History

Displays the following session-related information:

• Sessions. Indicates the number of sessions (different SPIDs) that were connected to the Sybase instance during the last sample.
• Active Sessions. Number of sessions (different SPIDs) connected to the Sybase instance during the last sample that were not in a state that is not part of the In Sybase group.
• Locked Sessions. Number of blocked sessions in the last sample.

Displays information on the following statistical parameters:

• CPU Time. Cumulative CPU time for all sessions connected to the instance during the last minute.
• Physical I/O. The total number of physical I/O requests performed by all sessions connected to the instance during the last minute.
• Memory Pages Used. Displays the total number of memory pages, currently used by all of the open sessions.

Displays the following session-related information:

• Sessions. Number of sessions (different SPIDs) that were connected to the database during the last sample.
• Active Sessions. Number of sessions (different SPIDs) connected to the database during the last sample that were not in Request Wait state.
• Locked Sessions. Number of blocked sessions connected to the database during the last sample.

Displays information on the following statistical parameters:

• CPU Time. Cumulative CPU time for all sessions connected to the database during the last minute.
• Physical I/O. Total number of physical I/O requests performed by all sessions connected to the database during the last minute.
• Memory Pages Used (Total). Displays the total memory (in pages) consumed by all sessions that were opened in Sybase during the last 15 minutes and were connected to the current database.

Displays information on the following session identifiers:

• State. Current state of the session.
• In Sybase. Graphical representation of the Time column. Text -Text of the statement which is currently running.
• Status. Current status of the session as reported by Sybase. The Session status can be one of the following:
• Alarm sleep. Waiting for alarm to wake process up.
• Background. A process, such as a threshold procedure, run by Adaptive Server rather than by a user process.
• Infected. Server has detected a serious error condition; extremely rare.
• Latch sleep. Waiting on a latch acquisition.
• Lock sleep. Waiting on a lock acquisition.
• PLC sleep. Waiting to access a user log cache.
• Recv sleep. Waiting on a network read.
• Remote I/O. Performing I/O with a remote server.
• Runnable. In the queue of runnable processes.
• Running. Actively running on one of the server engines.
• Send sleep. Waiting on a network send.
• Sleeping. Waiting on a disk I/O, or some other resource (often indicates a process that is running, but doing extensive disk I/O).
• Stopped. Stopped process.
• Sync sleep. Waiting on a synchronization message from another process in the family.
• Last Batch Time. If the session is currently executing a batch, this field displays the time the batch started; otherwise it displays the time the previous batch finished executing. Idle Time -Time elapsed since last batch.
• Parallel Sessions. Current number of sub-threads used to execute a batch in parallel. This counter is calculated from the fid column in the sysprocesses. It enables you to verify that Sybase uses the best execution plan for the current statement.
• Blocked By. If the session is blocked by another session, displays the SPID of the blocker session.

The following information is displayed:

• Session status. Current status of the session as reported by Sybase.
• Last Batch Time. If the session is currently executing a batch, this field displays the time the batch started; otherwise it displays the time the previous batch finished executing.
• Idle Time. Time elapsed since last batch.

Displays the resource consumption breakdown of the session during the last minute (that is, 60 samples of the Collector agent).

It is important to remember that since this view only displays the last minute's activities, you will always be viewing the activities that occurred during the last minute and not the activities that occurred since the last refresh action.

The following information is displayed:

• In Sybase. Graphical representation of the Time column.
• Time. Amount of time the selected entity was in this state.
• %. Percentage of time the selected entity was in this state.

Displays information on the current session locks that exists in the instance. Contains the following information on each session:

• Blocked by. If the session is blocked by another session, displays the SPID of the blocker session.
• Blocker user/program.
• Locking chain. For more than one locked session.
• Lock wait. Lock duration.

Displays information on the following statistical parameters:

• CPU Time. CPU time for the sessions during the last minute.
• Physical I/O Operations. Total number of physical I/O requests performed by the session during the last minute.
• Memory Pages Used. Number of pages in the procedure cache that are currently allocated to the SPID.

Displays the resource consumption breakdown of the statement or batch during the last minute (that is, 60 samples of the Collector agent). In addition to the resource distribution, the view displays the number of sessions in each state during the last sample.

It is important to remember that since this view only displays the last minute's activities, you will always be viewing the activities that occurred during the last minute and not the activities that occurred since the last refresh action.

The following information is displayed:

• State. Displays the In Sybase state.
• In Sybase. Graphical representation of the Time column.
• Time. Amount of time the selected entity was in this state.
• %. Percentage of time the selected entity was in this state.