Page History
...
The Statement entity displays access plan details and resource consumption for the selected statement. The following views are available:■ Overview
- Overview
...
- Performance
...
- SQL Text
About getting an overview of a statement
The Overview displays general details about the statement, along with details regarding its last access plan, as follows:Statement Displays
- Statement. Displays general statement details such as statement ID, database and parsing user.
- Access
...
- Plan. Provides details regarding to the last access plan of the statement, such as whether a table scan, index seek and index scan was performed.
About viewing the performance of a selected statement
The Performance view displays resource consumption information on the selected statement, as follows:
- In MS-
...
- SQL. Displays resource consumption information for the selected statement, over the selected time period.
- Statement
...
- Executions. Displays the number of statement executions carried out over the selected time period.
About viewing the SQL text of a selected SQL statement
The SQL Text view displays the text of the selected SQL statement.
About the Statement entity Association area
You can view general details on the entities associated with the selected Statement entity in the Association area. It is possible to associate to the Statement entity from the Table and Index entities.
The following tabs are available provide additional information in the Association area:Performance Provides
- Performance. Provides general details and resource consumption of the statement.
...
- Plan. Displays details on the last access plan of the statement such as whether a Table Scan was used, and whether an Index Seek was.
| Anchor | ||||
|---|---|---|---|---|
|
The Batch entity displays access plan details and resource consumption for the selected batch. The following views are available:■ Overview
- Overview
...
- Performance
...
- SQL Text
About getting a general overview of batch details
The Overview displays general batch details such as last show plan and most recent plan, in addition to details regarding the selected batch's last access plan, as follows:Batch Displays
- Batch. Displays general details of the batch such as database and parsing user.
- Access
...
- Plan. Displays details on the last access plan of the batch such as, whether a table scan or index scan was performed.
About viewing the performance of a batch
The Performance view displays resource consumption and number of statement executions for a statement, as follows:
- In MS-
...
- SQL. Displays resource consumption information for the selected statement, over the selected time period.
- Statement
...
- Executions. Displays the number of statement executions carried out over the selected time period.
About viewing the SQL text of a batch
The SQL Text view displays the batch's text.
About the Batch entity Association area
You can view general details on the entities associated with the selected Batch entity in the Association area. It is possible to associate to the Batch entity from the Table and Index entities.
The following tabs are available in the Association area:Performance Displays
- Performance. Displays general details and resource consumption for the selected batch.
...
- Plan. Displays details on the last access plan of the selected batch such as whether a table scan or index seek was used.
| Anchor | ||||
|---|---|---|---|---|
|
The Physical Disk entity displays general details and I/O wait data for the selected physical disk.
About getting an overview of general physical disk details
The Overview displays general physical disk details along with I/O wait data for the selected physical disk, as follows:Properties Displays
- Properties. Displays general physical disk details such as type, and number of logical volumes.
- I/O
...
- Wait. Displays the I/O wait on the selected physical disk as collected by Precise for SQL Server Collector over the specified time period.
About the Physical Disk entity Association area
You can view general details on the entities associated with the selected Physical Disk entity in the Association area. It is possible to associate to the Physical Disk entity from the following entities: Database, Table, Index, Logical File, File Group, Logical Volume, Disk Partition, HP Storage Device and HDS Storage Device.
...
The Logical Volume entity displays general details and storage utilization for the selected logical volume.
About getting an overview of logical volume details
The Overview displays general logical volume details, in addition to the free space and used space of the selected logical volume, as collected by the Collect Space Utilization process over the specified time period, as follows:Properties Displays
- Properties. Displays general details of the logical volume such as type, and number of Logical files stored in the logical volume.
...
- Storage. Displays the free space and used space of the selected logical volume as collected by the Collect Space Utilization process over the specified time period.
About the Logical Volume entity Association area
You can view general details on the entities associated to the selected Logical Volume entity in the Association area. It is possible to associate to the Logical Volume entity from the following entities: database, table, index, logical file, file group, physical disk, disk partition, HP storage device and HDS storage device.
...
The Disk Partition entity displays general details for the selected disk partition, such as disk partition number in physical disk and disk partition number in logical volume, disk partition offset and length.
About the Disk Partition entity Association area
You can view general details on the entities associated to the selected Disk Partition entity in the Association area. It is possible to associate to the Disk Partition entity from the Physical Disk, Logical Volume, HP Storage Device and HDS Storage Device entities.
...
For more information about the Storage Device entity, see “About Storage Unit entities” on page 137.
About the Storage Unit entity Association area
You can view general details on the entities associated to the selected Storage Units in the Association area. This information is based on the mapping carried out by the Precise for SQL Server Storage agents that are installed.
...