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 additional information is available for SQL Server 2005 and later objects:
- Partitions. Indicates the number of partitions defined for the selected index.
- Index Partitioned. Indicates whether or not the index is partitioned.
- Partition Schema. Indicates under which file groups to map the partition.
- Partition Function. Displays the name of the function that defines how the index should be partitioned.
- Index Aligned. Indicates whether or not the index is aligned with its table.
- Number of Non-key Columns. Displays the number of non-key columns used within an index.
- Index Non-Key Columns. Displays the non-key column names.
...
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.
...