Page History
...
The table below describes which Collector entities can be examined in the Activity tab.
Table 6- 1 Collector entities that can be examined in the Activity tab
Collector Entity | Description |
---|---|
Database | Displays information on an activity in reference to a specific database. |
Program | Displays information on an activity generated from a specific program. Displays 'N/A' if the program_name column in sysprocesses is null. |
Login | Displays information on an activity generated by a specific login. Displays 'N/A' if the suid column in sysprocesses holds a number for which the user name is null. |
User | Displays information on an activity generated by a specific user in the database in use. |
Machine | Displays information on an activity generated from a specific workstation. If the hostname column in sysprocesses is null, displays the IP Address of the workstation for instances of version 12.5 or later, or 'N/A' for instances of earlier versions. |
See Precise for Sybase agents on page 13.
...
The table below describes the additional information displayed in the Performance tab in the Association area.
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 table below describes which performance and resource consumption information is displayed for the statement, batch, collapsed statement and collapsed batch entities.
Table 6- 3 Statement, Batch, Collapsed Statement and Collapsed Batch entities
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.
...
The table below describes the additional information displayed in the Performance tab in the Association area.
Table 6- 4. Information displayed in the Performance tab
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 table below describes the additional information displayed in the Statistics tab in the Association area.
Table 6- 5 Information displayed in the Statistics tab
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 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. | |
Entity Name (such as Statement) | Displays the name of the entity. |
Database | Identifies the database on which the statement or batch is run. |
User | Displays one of the Sybase users by whom this statement was executed. If this statement is not part of a stored procedure, this user will be used as parsing user when explaining this batch. |
Most Recent Plan | Indicates the last time the access path of the statement or batch was changed. |
Last Show Plan | Indicates the last time the statement or batch was explained. |
Cost | Indicates the total estimated cost of the statement's or batch's execution. |
Table Scan | Indicates whether a table scan was performed in the execution plan (applicable to Statement entity only). |
Clustered Index Scan | Indicates whether a clustered index scan was performed in the execution plan (applicable to Statement entity only). |
Clustered Index Seek | Indicates whether a clustered index seek was performed in the execution plan (applicable to Statement entity only). |
Index Scan | Indicates whether an index scan was performed in the execution plan (applicable to Statement entity only). |
Index Seek | Indicates whether an index seek was performed in the execution plan (applicable to Statement entity only). |
Table Lookup | Indicates that a table lookup operation was performed in the execution plan (applicable to Statement entity only). |
Sort | Indicates whether a sort operation was performed in the execution plan (applicable to Statement entity only). |
Merge Join | Indicates whether a merge join operation was performed in the execution plan (applicable to Statement entity only). |
Join | Indicates that a join (other than merge join) operation was performed in the execution plan (applicable to Statement entity only). |
Nested Loops Join | Indicates whether a nested loops join operation was performed in the execution plan (applicable to Statement entity only). |
Parallel Access | Indicates whether a parallel access operation was performed in the execution plan (applicable to Statement entity only). |
Show Plan Errir | Shows the error that occurred during the last explain process. |
Collapsed Statement and Collapsed Batch entities Association area
...
The table below describes the additional information displayed in the Performance tab in the Association area.
Table 6- 7 Information displayed in the Performance tab
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 table below describes the additional information displayed in the Statistics tab in the Association area.
Table 6- 8 Information displayed in the Statistics tab
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 table below describes the additional information displayed in the Performance tab in the Association area.
Table 6- 9 Information displayed in the Performance tab
Column | Description |
---|---|
SPID | Displays the system process ID. The SPID is a unique integer assigned to each user connection when the connection is made. |
Program | Displays the program that opened the session. |
In Sybase | Displays entity resource consumption (default: stacked bar chart) and shows entity breakdown over the specified time period. |
Database | Displays the database used by session. |
Login | Displays the Sybase login that opened the session. |
Stat Time | Displays when the session was started during the selected time frame. |
Completed At | Displays when the session was completed during the selected time frame. |
Machine | Displays the machine the program ran on. |
User | Displays the database user that opened the session. |
Duration (Summed) | Displays the time that has elapsed since the login time. |
Client Process ID | Displays the process ID of the program. |
About viewing In Sybase data for Session and Blocker Session entities
...
The table below About viewing statistical data for Session and Blocker Session entities.
Table 6- 10 Information displayed in the Statistics tab
Column | Description |
---|---|
SPID | Displays the system process ID. The SPID is a unique integer assigned to each user connection when the connection is made. |
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 session during the selected time frame. |
Memory Pages Used | Displays the memory consumed (in pages) by the selected session during the selected time frame. |
See Understanding In Sybase session states on page 25.
...
- In the Instance list, choose the item you want to analyze.
- In the Time Frame list, choose the period of time you want to analyze.
- On the View controls in the Main area, click Scalability.
- In the Session Duration (Avg) vs. Sessions graph, observe the number of sessions and the impact of the average session duration, over the selected time period. For example, if you observe that average session duration decreases when the number of sessions increase, this may indicate that the application has a scalability problem.
...
- .
...
...