Page History
...
- About the Objects tab
- How the Objects tab is structured
- About Objects tab entities
- About the Instance entity
- About the Database entity
- About the Active Objects entity
- About the Table and Table Contain Same Column entities
- About the Partition entity (SQL Server 2005 only)
- About the Column entity
- About the View and View contain Same Column entities
- About the User entity
- About the Logical File entity
- About the File Group entity
- About the Statistics entity
- About the Stored Procedure entity
- About the Function entity
- About the Trigger entity
- About the Statement entity
- About the Batch entity
- About the Physical Disk entity
- About the Logical Volume entity
- About the Disk Partition entity
- About the Storage Unit entity
- How the Objects tab can help you identify performance problems
...
You can view general details on the entities that are associated with the selected Partition entity in the Association area. It is possible to associate to the Partition entity from an Index or Table entity.
| Anchor | ||||
|---|---|---|---|---|
|
The Column entity displays general details and schema changes for the selected column. The following views are available:
...
SQL Server 2005 allows you to extend the functionality of non-clustered indexes by adding non-key columns to the leaf level of the non-clustered index. This allows you to create non-clustered indexes that cover more queries, thereby considerably improving query performance. The Non-Key Column field (displayed for SQL Server 2005 non-clustered indexes only), indicates whether or not the selected column is a non-key column.
| Anchor | ||||
|---|---|---|---|---|
|
The View entity displays general details and schema changes for the selected view.
...
You can display general details on the entities that can be associated with the selected View entity in the Association area. It is possible to associate to the View entity from the Database, Table, Column and Index entities.
| Anchor | ||||
|---|---|---|---|---|
|
The User entity displays general details of the selected user, such as, Roles and Database Access.
...
You can view general details on the entities that can be associated to the selected User entity in the Association area. It is possible to associate to the User entity from the Database entity.
| Anchor | ||||
|---|---|---|---|---|
|
The Logical File entity displays general details, I/O activity and storage information on the selected database file.
...
You can view general details on the entities associated to the Logical File entity in the Overview tab in the Association area. The Statistics tab shows information on I/O wait, bytes requested, number of requests, and size of logical files. It is possible to associate to the Logical File entity from the following entities: Instance, Database, File Group, Physical Disk, Logical Volume, HP Storage Device, HDS Storage Device, Symmetrix Storage Device and Clariion Storage Device.
| Anchor | ||||
|---|---|---|---|---|
|
The File Group entity displays general details and space utilization, over the selected time period, for the selected file group.
...
You can view general details on the entities that are associated to the selected File Group in the Association area. It is possible to associate to the File Group from the following entities: Database, Table, Index, Logical File, Physical Disk, Logical Volume, HP Storage Device and HDS Storage Device.
| Anchor | ||||
|---|---|---|---|---|
|
The statistic entity displays distribution statistics on the selected collection (set of columns). The following views are available:
...
You can view general details on the selected Statistics entity in the Association area. It is possible to associate to the Statistics entity from the Table and Column entities.
| Anchor | ||||
|---|---|---|---|---|
|
The stored procedure entity displays general details and resource consumption of the selected stored procedure. The following views are available:
...
You can view general details on the entities associated with the selected Stored Procedure entity in the Association area. It is possible to associate to the Stored Procedure entity from the Database, Table, View, User, Stored Procedure and Function entities.
| Anchor | ||||
|---|---|---|---|---|
|
The function entity displays general details and resource consumption of the selected function. The following views are available:
...
You can view general details on the entities associated with the selected Function entity in the Association area. It is possible to associate to the Function entity from the Database, Table, View, User, Stored Procedure and Function entities.
| Anchor | ||||
|---|---|---|---|---|
|
The trigger entity displays general details and resource consumption of the selected trigger. The following views are available:
...
You can view general details on the entities associated with the selected Trigger entity in the Association area. It is possible to associate to the Trigger entity from the Database, Table, View and User entities.
| Anchor | ||||
|---|---|---|---|---|
|
The Statement entity displays access plan details and resource consumption for the selected statement. The following views are available:
...
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:
...
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.
...
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.
| Anchor | ||||
|---|---|---|---|---|
|
The Logical Volume entity displays general details and storage utilization for the selected logical volume.
...
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.
| Anchor | ||||
|---|---|---|---|---|
|
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.
...
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.
| Anchor | ||||
|---|---|---|---|---|
|
The Storage Unit entity displays a list of all storage entities connected to instances in the Tier. The Storage Unit entity can only be associated to from the Instance level.
...