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.

Data Partitioning

Native table and index partitioning capabilities are new for SQL Server 2005 Enterprise Edition only. Partitioning can significantly improve query performance ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.