There are several new features and built-in support within SQL Server 2005 that provide potential for improved system performance and for monitoring performance. Data partitioning, the ability to partition table data and indexes into horizontal partitions, can help with performance and manageability of data. There are new query hints and query plan guides available to help improve performance and to improve query plan reuse. There are also new dynamic management system views for monitoring performance information. Each of these is described in the following sections.
Native table and index partitioning capabilities are new for SQL Server 2005 Enterprise Edition only. Partitioning can significantly improve query performance ...