Page History
...
Column | Description |
---|---|
Click to launch the SQL tab with the selected entity, to continue your analysis of the selected statement or batch. | |
Entity Name (Such as Statement) | Displays the name of the entity. |
CPU Time | Cumulative CPU time for the entity during the selected time frame. |
Physical I/O Operations | Total number of physical I/O requests performed by the selected entity during the selected time frame. |
Parallel Sessions (Min) | Minimum number of threads used to execute the statement or batch in parallel. This counter is calculated from the fid column in sysprocesses . This enables you to verify that Sybase is using the best execution plan for the current statement. |
Parallel Sessions (Max) | Maximum number of threads used to execute the statement or batch in parallel. This counter is calculated from the fid column in sysprocesses . This enables you to verify that Sybase is using the best execution plan for the current statement. |
...
Column | Description |
---|---|
Entity Name (Such as Collapsed Statement) | Displays the name of the entity. |
Database | Identifies the database on which the collapsed statement or batch is run. |
CPU Time | Cumulative CPU time for the entity during the selected time frame. |
Physical I/O Operations | Total number of physical I/O requests performed by the selected entity during the selected time frame. |
Parallel Sessions (Min) | Minimum number of threads used to execute the statement or batch in parallel. This counter is calculated from the fid column in sysprocesses . This enables you to verify that Sybase is using the best execution plan for the current statement. |
Parallel Sessions (Max) | Maximum number of threads used to execute the statement or batch in parallel. This counter is calculated from the fid column in sysprocesses . This enables you to verify that Sybase is using the best execution plan for the current statement. |
...
- Overview
- In Sybase
- Locking
- Overall Activity
About getting an overview of Session and Blocker Session entities
The Overview displays general details on the selected session or blocker session, such as, Machine, Login, and Client Process ID. A breakdown of the selected session's or blocker session's resource consumption is also displayed.
About viewing In Sybase data for Session and Blocker Session entities
The In Sybase view displays the resource consumption of the selected session during the selected time frame. This graph enables you to analyze performance trends for the session, over time.NOTE The
Info |
---|
The graph displays data in time slices. |
See Understanding In Sybase session states on page 25. See Focusing on information in overtime graphs on page 22.
About viewing Session and Blocker Session locking
The Locking view displays the blocking tree and the lock wait duration broken down into lock levels (such as, Table, Page, and Key) for the selected entity, over the selected time period. The following information is displayed:Locks Displays
- Locks. Displays which sessions were involved in a blocking situation (either locking or blocking). It is important to understand which sessions are involved in each blocking chain, as there may be several sessions involved at the same time. It is then important to determine which session is blocking others, which object is being blocked, and what type of lock has been applied.
A yellow lock indicates that the session is currently blocking another session but is not itself blocked.
A red lock indicates the session is currently blocked by another session. Note that a session may also block other sessions while being blocked by a different session. Lock wait
...
graph. The Lock Wait graph shows a breakdown of the Lock Waits and when they occurred over the selected time period.
Info
...
The graph displays data in time slices.
About viewing overall activity for Session and Blocker Session entities
The Overall Activity view displays the duration of the activity performed by the selected session within the specified time period, broken down into the following components:
- Waitfor Command. The amount of time applications were waiting for a Waitfor command.
- Parallel Sync Wait. The amount of time applications were waiting on a synchronization message from another process in the family.
- Request Wait. The amount of time applications were in a request wait state, defined as the state wherein the server is waiting for a client request.
- Other Wait. The amount of time applications were in other states.
- In Sybase. Represents total amount of time spent in Sybase.
Info |
---|
...
The graph displays data in time slices. |
See Focusing on information in overtime graphs on page 22.
Session and Blocker Session entities Association area
The following tabs are displayed in the Association area of the Instance and Collector entities:
...
Clicking a tab shows additional information on the entities displayed in the Association area table. The rows of the table remain the same; the columns change to display additional details on the entities listed in the table. The following table describes the information displayed in each tab.
About viewing performance data for Session and Blocker Session entities
The table below describes the additional information displayed in the Performance tab in the Association area.
Table 6-9 Information 9 Information displayed in the Performance tab
Column Description
...
Column | Description |
---|---|
SPID | Displays the system process ID. The SPID is a unique integer assigned to each user connection when the connection is made. |
Program |
...
Displays the program that opened the session. |
In |
...
Sybase | Displays entity resource consumption (default: stacked bar chart) and shows entity breakdown over the specified time period. |
Database |
...
Displays the database used by session. |
Login |
...
Displays the Sybase login that opened the session. |
Stat |
...
Time | Displays when the session was started during the selected time frame. |
Completed |
...
At | Displays when the session was completed during the selected time frame. |
Machine |
...
Displays the machine the program ran on. |
User |
...
Displays the database user that opened the session. |
Duration (Summed) |
...
Displays the time that has elapsed since the login time. | |
Client Process |
...
ID | Displays the process ID of the program. |
About viewing In Sybase data for Session and Blocker Session entities
The In Sybase tab contains the In Sybase counter and the breakdown of In Sybase into its states. In Sybase is displayed with a normalized view while all the other counters display the time spent in each state.
About viewing statistical data for Session and Blocker Session entities
The table below About viewing statistical data for Session and Blocker Session entities.
Table 6-10 Information 10 Information displayed in the Statistics tab
Column Description
...
Column | Description |
---|---|
SPID | Displays the system process ID. The SPID is a unique integer assigned to each user connection when the connection is made. |
CPU |
...
Time | Cumulative CPU time for the entity during the selected time frame. |
Physical I/O |
...
Operations | Total number of physical I/O requests performed by the selected session during the selected time frame. |
Memory Pages |
...
Used | Displays the memory consumed (in pages) by the selected session during the selected time frame. |
See Understanding In Sybase session states on page 25.
...