Page History
...
Table 5-4 Statement or Batch overview
| Parameter |
|---|
...
| Description |
|---|
| Statement/Batch |
...
| ID | Internal statement hash value (SHV) calculated by the Collector agent. |
| Database |
...
| Identifies the database on which the statement or batch is run. This information is used by Precise for Sybase to display the statement's execution plan. |
| User |
...
| Displays the parsing user who runs the statement or batch. This information is used by Precise for Sybase to display the statement's execution plan. |
| Executions |
...
| Number of times the Collector agent identifies that the statement or batch was executed. |
| Duration |
...
| Total time required to execute the selected statement or batch during the last time slice. |
| Duration (Avg) |
...
| Average duration of each statement execution during the last time slice. | |
| CPU |
...
| Time | Cumulative CPU time for the statement during the last time slice. |
Table 5-4 Statement or Batch overview
Parameter Description
| Physical I/O |
...
| Operations | Total number of physical I/O requests during the execution of the statement or batch during the last time slice. |
| 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. | |
| In Sybase (Last minute) |
...
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: |
...
|
...
|
...
|
...
|
See How information is collected on page 25.
About viewing current Statement or Batch text
Displays text of the selected statement or batch.
About the Statement and Batch Association area
It is possible to view statement or batches in the Association area while drilling down from a single session. The table includes only statements or batches that were executed during the last time frame. A time frame is a 15-minute interval. If a statement or batch was executed in an earlier time frame, this statement or batch no longer appears in the Current tab. Instead, you can view information on this statement or batch in the Activity tab.
The table below describes the information displayed in the Association area, when viewing a statement or batch entity.
Table 5-5 Statement5 Statement/Batch Association table
| Association |
|---|
...
| Tab | Function |
|---|---|
| General | Shows general information on the displayed statements or batches. |
| In |
...
| Sybase | Shows information on performance and statistics of the displayed statements or batches |
...
| . | |
| Statistics | Shows |
...
| statistics of the displayed statements or batches. |
See About session states on page 25.See , Understanding In Sybase session states on page 25.See , and Understanding Non-In Sybase session states on page 27.
...
You can identify a performance problem by doing one or more of the following:• See
- See Examining the resource consumption of an entire instance and database on page 47.
...
- See Observing session activity on page 47.
...
- See Examining a single connection on page 47.
Examining the resource consumption of an entire instance and database
The Current tab provides an almost real-time picture of the performance and behavior of your Sybase instance. It displays information on the last minute of activity.
To examine the resource consumption of an entire instance and database1. Examine
- Examine the activities of the entire instance level to determine what is happening in your system.
...
- Examine the current activity at an instance level of display to see how the system is currently behaving and determine if there is an overall problem that affects all sessions or if there is a problem with specific sessions.
...
- Start your investigation in the Overview view of an Instance or Database entity. This will show you a breakdown of resource consumption for the last minute.
Observing session activity
In the Association area you can see which sessions are currently connected to the Instance, or view which sessions are currently using a specific database or holding a specific object.
To observe session activity1. Observe
- Observe the current state of the session and determine if it is active or waiting for a resource.
...
- Identify the session by different identifiers such as its login, the machine it is running on, or the programs it is running. The current active SQL code is displayed for active sessions.
...
- If you have hundreds of sessions running, and you want to focus your investigation on the sessions that were active in Sybase during the last minute, select Active Sessions from the Association Controls in the Association area.
Examining a single connection
You may need to explore a single running SPID, to obtain more information for it. To examine a single connection1. Drill
- Drill down to the specific SPID in question. Continue examining its resource breakdown, its recent statements, or the batches in which the session was executed, during the last few minutes.
...
- Check if the session is blocked and by whom.
...
Precise. Performance intelligence from click to storage. Learn more > >