Page History
...
Table 6-2 Precise information displayed in the Performance tab
Column |
---|
...
Description |
---|
Entity Name ( |
...
Such as Instance, Database) |
...
Displays the name of the entity. | |
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. |
...
Sessions | Number of sessions that occurred during the selected time frame of the selected entity. |
Duration (Avg) |
...
Average duration for a single session, in the selected entity during the selected time frame, calculated by dividing the Duration by the number of Sessions. | |
Statement |
...
Executions | Number of statements executed during the selected time frame that were generated by the selected entity's sessions. |
CPU |
...
Time | Cumulative CPU time for the entity during the selected time frame. This value is calculated by the Collector agent as follows (this is an approximate value): The |
Physical I/O |
...
Operations | Cumulative number of physical I/O requests performed for the entity during the selected time frame. This value is calculated by the Collector agent as follows (this value is an approximation): The |
About viewing In Sybase data for Instance and Collector entities
The In Sybase tab contains the In Sybase counter and the breakdown of the In Sybase into its states. The In Sybase is displayed with a normalized view while all the other counters display the time spent in each state.
...
The table below describes which performance and resource consumption information is displayed for the statement, batch, collapsed statement and collapsed batch entities.
Table 6-3 Statement3 Statement, Batch, Collapsed Statement and Collapsed Batch entities
Entity Description
...
Entity | Description |
---|---|
Statement | Displays information on the activity of a specific TSQL statement. A statement is always part of a batch. When an encrypted stored procedure is encountered the statement will display Encrypted Text. |
...
Batch | Displays information on the activity of a specific batch. A batch can either be a stored procedure, stored function, trigger, or a detailed batch. If it is a stored object, the name of the stored object is displayed. |
Collapsed |
...
Statement | Represents similar statements that differ in their parameters (literals). In a collapsed statement, the literals are replaced with parameter markers. The collapsed statement lets you analyze the overall resource consumption of similar statements. |
Collapsed |
...
Batch | Similar to collapsed statement a collapsed batch represents similar batches that differ in their parameters (literals). In a collapsed batch, the literals are replaced with parameter markers. The collapsed batch lets you analyze the overall resource consumption of similar batches. |
See How information is collected on page 25.
...
- Overview
- Text
- In Sybase
- Locking
- Scalability
About getting an overview of Statement, Collapsed Statement, Batch and Collapsed Batch entities
The Overview displays information on the entity's activity, such as its number of executions and average statement duration. In addition the resource consumption breakdown and the text of the statement or batch are also displayed, as follows:Load Displays
- Load. Displays information on the following session-related items:
- Database
- . Identifies the statement's database.
- User
- . Identifies the statement's parsing user.
- Statement Executions
- . Number of times the Collector agent identifies that the statement was executed during the selected time frame.
- Statement Duration (Avg)
- . Displays the average duration of each statement execution during the selected time frame, calculated by dividing the Duration (Summed) by the number of Statement Executions.
- Statement Duration (Summed)
- . Total elapsed time required to run all executions of the selected statement or batch during the selected time frame.
...
- Statistics. Displays the following statement-related statistics:
- CPU Time
- . Cumulative CPU time for the entity during the selected time frame. This value is calculated by the Collector agent as follows (this is an approximate value) - the CPU field in
sysprocesses
is sampled at the start point and end point. The value sampled at the start point is subtracted from the value sampled at the end point resulting in the CPU Time reported. - Physical I/O Operations
- . Total number of physical I/O requests during statement execution during the selected time frame.
- Parallel Sessions (Min)
- . Certain statements are executed using parallelisms. This counter displays the minimum number of threads used to execute the statement and is calculated by examining the fid column in
sysprocesses
. Check this counter to verify that the Sybase is implementing the best execution plan for the statement. - Parallel Sessions (Max)
- . Certain statements are executed using parallelisms. This counter displays the maximum number of threads used to execute the statement and is calculated by examining the fid column in
sysprocesses
. Check this counter to verify that the Sybase is implementing the best execution plan for the statement.
- In Sybase
...
- breakdown. Displays resource consumption broken down into states, such as, Using CPU, I/O Wait, Lock Wait, and so on, within the specified time period. This allows you to identify the highest resource consumers.
...
- Text. Displays statement or batch text (formatted for easy readability).
When viewing a batch entity, the entire text of the improvised batch or stored object is displayed. When viewing a statement, only the part of the batch that generates the statement is displayed. When viewing a collapsed statement or batch, the literals are replaced with parameter markers.
About viewing Statement, Collapsed Statement, Batch and Collapsed Batch text
The Text view displays the SQL Text of the statement or batch.
About viewing In Sybase data for Statement, Collapsed Statement, Batch and Collapsed Batch entities
The In Sybase view displays the resource consumption of the selected entity during the selected time frame. This graph enables you to analyze performance trends for the entity, over time.
See Focusing on information in overtime graphs on page 22.
About viewing Statement, Collapsed Statement, Batch and Collapsed Batch entities 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.
See Focusing on information in overtime graphs on page 22.
About viewing scalability for Statement, Collapsed Statement, Batch and Collapsed Batch entities
The Scalability view displays an over time graph that allows you to examine the scalability of the selected collector entity during the selected time frame. For example, you can determine whether the average statement In Sybase time of an entity's activity increased as a result of an increase in number of executions.
The following over time graph is displayed:
- In Sybase (Avg) vs.
...
- executions. Compares the average In Sybase time of the selected entity with the number of executions during the selected time frame. For example, if the selected entity is a Statement, the graph will show the number of executions of the selected statement versus the average In Sybase time of each execution over time. Use this graph to analyze if the average statement In Sybase time increases when the number of executions increase.
Statement and Batch entities Association area
The following tabs are displayed in the Association area of the Statement and Batch 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 tables describe the information displayed in each tab.
About viewing performance data for Statement and Batch entities
The table below describes the additional information displayed in the Performance tab in the Association area.
Table 6-4 Information 4. Information displayed in the Performance tab
Column Description
...
Column | Description |
---|---|
Click to launch the SQL tab with the selected entity, to continue your analysis of the selected statement or batch. | |
Entity |
...
Name | Displays the name of the entity (statement or 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. |
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's text. |
About viewing In Sybase data for Statement and Batch 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 Statement and Batch entities
The table below describes the additional information displayed in the Statistics tab in the Association area.
Table 6-5 Information 5 Information displayed in the Statistics tab
Column Description
...
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. |
About viewing Plan data for Statement and Batch entities
The table below describes the additional information displayed in the Plan tab in the Association area.
Table 6-6 Information 6 Information displayed in the Plan tab
Columns Description
Click to launch the SQL tab with the selected entity, to continue your analysis of the selected statement or batch.
...