Page History
...
- Availability. Displays the percentage of time the SQL Server was available (including planned down time; for more information see the Precise Administration Guide).
- Unavailability times. Displays how long the SQL Server was down. If the Precise for SQL Server Collector was down, the status will be labeled "Unknown Time.".
- Log. Provides general information regarding each period that the SQL Server was down.
Provide information on the status of SQL Server instance, over the selected time period. If the instance was down or if the status was unknown (the Collector was down) during the selected time period, only information on the unavailability of the instance is displayed (time range of the unavailability period).
...
| 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”.displays, "Encrypted Text." |
| Batch | Displays information on the activity of a specific batch. A batch can either be a stored procedure, stored function, trigger, or an ad hoc batch. If it is a stored object, the name of the stored objects are 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. |
| Info |
|---|
The information displayed for certain entities may differ slightly than that described, as is relevant for the specific entity. For example, if you have navigated to a storage entity (such as a database file), only the I/O wait information for the selected entity is displayed. If you have navigated to a locked object, only the Lock wait information is displayed. |
See “About Statement identifiers” on page 38 About Statement identifiers.
The following views are available for the Statement, Batch, Collapsed Statement and Collapsed Batch entities:
...
- Load. Elapsed time Execution count Avg average duration.
- Statistics.
- Recompilations
- CPU time
- CLR time
...
| 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 period. |
| Physical I/O Operations | Total number of physical I/O requests performed by the selected entity over the selected time period. |
| Parallel Sessions (Min) | Minimum number of threads used to execute the statement or batch in parallel. This counter is calculated from the This enables you to verify that SQL Server 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 This enables you to verify that SQL Server is using the best execution plan for the current statement. |
About viewing Procedure Cache data for Collapsed Statement and Collapsed Batch entities
...