Page History
...
The Overview displays a summary of the performance and resource consumption of all instances in the application, as follows:
- Instances. Displays the number of Instances defined in the Tier.
In MS-SQL breakdown table. Displays the resource consumption breakdown of all the instances over the selected time period, as follows:
Info The table only displays the states the selected entity was in. For example, if the selected entity was not waiting for an I/O wait during the selected time period, the table will not display I/O wait parameters.
...
| 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. If ERP is installed, the program is updated with the ERP data. For more information, see extended ERP data. |
| Login | Displays information on an activity generated by a specific login. Displays ‘N/A' if the login name column in sysprocesses is null. If ERP is installed, the login is updated with the ERP data. For more information, see extended ERP data. |
| 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. Displays ‘N/A' if the hostname column in sysprocesses is null. If InterPoint for ERP is installed, the machine is updated with the ERP data. For more information, see extended ERP data. |
| Work Type | The Precise for SQL Server Collector divides SQL Server activities into several groups. The Work Type entity displays performance information on each group. The following groups are available:
The following groups are only displayed if InterPoint for ERP is installed: In SAP:
In PeopleSoft:
In Siebel:
|
| COM+ | For more information, see extended ERP/COM+ documentation. |
| ERP Data | For more information, see extended ERP/COM+ documentation. |
| Job | Displays information on an activity, with reference to a specific job. |
...
See “Focusing on information in overtime graphs” on page 32.
About the lock tree structure
To gain a better understanding of the lock tree let's take a look at its structure. Notice that the session located in the root of each chain is the session that blocks all others. Each session directly blocks all sessions positioned one level beneath it.
...
| Column | Description |
|---|---|
| Entity name (such as instance, database, etc.) | Displays the name of the entity. |
| In MS-SQL | Displays entity resource consumption (default: stacked bar chart) and shows entity breakdown, over the selected time period. |
| % | Displays the percentage of the total In MS-SQL. |
| Sessions | Number of sessions that occurred during the selected time period of the selected entity. |
| Duration (Avg) | Average duration for a single session, in the selected entity, during the selected time period, calculated by dividing the Duration by the number of Sessions. |
| Statement Executions | Number of statements executed within the selected time period that were generated by the selected entity's sessions. |
| CPU Time | Cumulative CPU time for the entity during the selected time period. This value is calculated by the Collector as follows (this value is an approximation)—the CPU Time 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. The start and end points are determined according to values that have changed. For example, a session is sampled by the Collector for five seconds, but the start and end points were calculated according to when a value has changed. As a result, the calculated CPU Time in this example is only three out of the sampled five seconds since this is takes into consideration when the value has changed. |
About viewing In MS-SQL data for Instance and Collector entities
...
- Statistics. Displays the following statement-related statistics:
- CPU Time. Cumulative CPU time for the entity during the selected time period. This value is calculated by the Collector as follows (this value is an approximation)—the CPU Time 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. The start and end points are determined according to values that have changed. For example, a statement is sampled by the Collector for five seconds, but the start and end points were calculated according to when a value has changed. As a result, the calculated CPU Time in this example is only three out of the sampled five seconds since this is takes into consideration when the value has changed.
- Physical I/O Operations. Total number of physical I/O requests during statement execution, within the selected time period.
- 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
ecidcolumn insysprocesses. Check this counter to verify that the SQL Server 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 ecid column in sysprocesses. Check this counter to verify that the SQL Server is implementing the best execution plan for the statement.
- In MS-SQL breakdown. Displays resource consumption broken down into states, such as, Using CPU, I/O Wait, Lock Wait, etc., 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 adhoc 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.
...
Table 6-5 Information displayed in the Performance tabDisplays entity resource consumption (default: stacked bar chart) and shows entity breakdown, over the selected time period.
| Column | Description |
|---|---|
 | Click to launch the SQL tab with the selected entity, to continue your analysis of the selected statement or batch. When launching to the SQL tab from a batch entity, the launch is performed in the context of the batch that has the latest explain statement performed on it. |
| Entity Name | Displays the name of the entity (statement or batch). |
| In MS-SQL | Displays entity resource consumption (default: stacked bar chart) and shows entity breakdown, over the selected time period. |
| % | Displays the percentage of the total In MS-SQL. |
| Statement Executions | Number of statements executed within the selected time period by the selected entity. |
| Statement Duration (Avg) | Average duration for a single statement, in the selected entity, during the selected time period, calculated by dividing the Statement Duration by the number of executions. |
| Text | Displays the statement's text (formatted for easy readability). |
...