Performance and Scalability

Published: November 7, 2005

Microsoft SQL Server 2005 incorporates several advances that greatly improve performance and scalability, including Service Broker, database snapshots, table and index partitioning, snapshot isolation, and support for non-uniform memory access (NUMA) and 64-bit systems.

These options help ensure that your organization has the flexibility it needs to grow confidently, without incurring the costs of migrating to an enterprise-sized database as data volume or number of users increases, as applications grow more complex, as availability and reliability become more important, or as your organization seeks to derive more value from its data through business intelligence initiatives. For more information about business intelligence in SQL Server 2005, visit the business intelligence solutions page.

SQL Server 2005 is designed to scale to support the needs of even the most demanding enterprise environment. Six of the world’s ten largest workloads for transaction processing run on SQL Server.

Customers using SQL Server in high throughput environments include:

NASDAQ

Hilton (57,000 TPS)

Pennzoil (1,100 TPS)

To learn more about how SQL Server outperforms other database platforms in demanding applications, visit the Performance and Scalability: SQL Server Benchmarks page.


Top of pageTop of page