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
...
The following views are available:■ Overview
- Overview
...
- Show Contig
...
- Statistics
...
- Schema Changes
...
- Usage Report
...
- Common Access Patterns (SQL Server 2005 only)
...
- Operational Statistics (SQL Server 2005 only)
About getting an overview of space utilization and schema changes for a selected index
The Overview displays space utilization and schema changes for a selected index, as follows:Properties Displays
- Properties. Displays general details on the index such as number of keys, fill factor, and whether the index is clustered or unique.
- In MS-
...
- SQL. Displays Using CPU and I/O Wait of the selected index over a selected time period, based on its contribution to overall performance when accessed by the execution plan.
- Space
...
- Allocation. Displays the amount of free space and used space (in MB) in the selected index, over the selected time period.
Note: The values may be incorrect due to out-of-date space usage information. To update the values, use the DBCC UPDATEUSAGE command to recalculate the space usage fields. For more information, see SQL Server Books Online.
...
Index Non-Key Columns Displays the non-key column names.
| Anchor | ||||
|---|---|---|---|---|
|
The Partition entity displays information on how an index or table is partitioned. All tables and indexes in a database are considered to be partitioned, in SQL Server 2005, even if they are made up of only one partition. The data of partitioned tables and indexes is divided into units that can be spread across more than one file group in a database. The data is partitioned horizontally, so that groups of rows are mapped into individual partitions.
...