Page History
...
| Info |
|---|
The Current tab displays information on the last minute of activity. For example, if you have worked at your screen for ten minutes and then refresh the information displayed on your screen, you will be able to view new information that occurred during the last minute of activity. |
See About the Dashboard tab on page 33.
| Anchor | ||||
|---|---|---|---|---|
|
...
In the Association area, click the row of the session that you want to view detailed information for. The Tab heading indicates the newly selected entity; the Main area displays detailed information on the session you drilled down to, and the Association area shows information on the statements associated with this session.
See About Precise for Sybase tabs on page 15 and and About the Dashboard tab on page 33.
| Anchor | ||||
|---|---|---|---|---|
|
...
| View Area | Description | ||
|---|---|---|---|
| Sessions | Displays the following session-related information:
| ||
| Statistics | Displays information on the following statistical parameters:
| ||
| In Sybase (Last Minute) | Displays the resource consumption breakdown of the instance 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 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 About session states on page 25.
About the Database entity
...
| View Area | Description | ||
|---|---|---|---|
| Session | Displays the following session-related information:
| ||
| Statistics | Displays information on the following statistical parameters:
| ||
| In Sybase (Last Minute) | Displays the resource consumption breakdown of the database 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 About session states on page 25.
About the Session entity
...
| View Area | Description |
|---|---|
| Session Tab | Displays information on the following session identifiers:
|
| Connection Tab | A connection includes session identifiers, such as database, login, machine and user, as reported by the sysprocesses.The following information is displayed:
|
| In Sybase (Last Minute) | 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:
|
| Locks Tab | Displays information on the current session locks that exists in the instance. Contains the following information on each session:
|
| Statistics Tab | Displays information on the following statistical parameters:
|
See About session states on page 25.
About viewing the current statement's text
...
| 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. |
| 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
...
| 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 See About session states on page 25, Understanding In Sybase session states on page 25, and Understanding Non-In Sybase session states on page 27.
| Anchor | ||||
|---|---|---|---|---|
|
You can identify a performance problem by doing one or more of the following :actions.
...
Examining the resource consumption of an entire instance and database
...
The Current tab provides an almost real-time picture of the performance and
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.
...
- 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 connection
- 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.