Page History
...
The table below describes the information displayed in the Instance overview.
Table 5- 1 Instance overview
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.
...
The table below describes the information displayed in the Database overview.
Table 5- 2 Database entity overview
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.
...
The table below describes the information displayed in the Session overview.
Table 5- 3 Session overview
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.
...
The table below describes the information displayed in the Statement or Batch overview.
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. |
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.
...
The table below describes the information displayed in the Association area, when viewing a statement or batch entity.
Table 5- 5 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, Understanding In Sybase session states on page 25, and Understanding Non-In Sybase session states on page 27.
...
- 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 > >
...