Page History
...
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 information displayed in each tab is described below.
About viewing performance data for Collapsed Statement and Collapsed Batch entities
The table below describes the additional information displayed in the Performance tab in the Association area.
Table 6-7 Information 7 Information displayed in the Performance tabColumn Description
Column | Description |
---|---|
Entity |
...
Name | Displays the name of the Collapsed Statement or Collapsed Batch. |
In |
...
Sybase | Displays entity resource consumption (default: stacked bar chart) and shows entity breakdown during the selected time frame. |
% |
...
Displays the percentage of the total In Sybase. |
Occurrences |
...
Number of different statements possessing the selected collapsed form. |
Statement |
...
Executions | Number of statements executed during the selected time frame by the selected entity. |
Statement Duration (Avg) |
...
Average duration for a single statement, in the selected entity during the selected time frame, calculated by dividing the Statement Duration by the number of executions. |
...
Text | Displays the statement or batch text, in the collapsed form. |
In Sybase tab (Collapsed Statement and Collapsed Batch)
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 Collapsed Statement and Collapsed Batch entities
The table below describes the additional information displayed in the Statistics tab in the Association area.
Table 6-8 Information 8 Information displayed in the Statistics tabColumn Description
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. |
About Session and Blocker Session entities
The Session entity displays performance, statistics and locking information on the selected session. This entity differs from other entities in the Activity tab in that session information is retrieved from the Collector agent's temporary files and not from the PMDB.
...