Performance and Scalability: SQL Server 2005 Enterprise Edition Benchmarks

Published: November 7, 2005 | Updated: July 24, 2007

Microsoft and Unisys are the first to publish TPC-E benchmark results
The new TPC Benchmark™ is an On-Line Transaction Processing (OLTP) workload developed by the Transaction Processing Performance Council. TPC-E is the successor to the venerable, but now 15 year old, TPC-C benchmark. TPC-E models an OLTP environment that is broadly representative of modern OLTP systems.

SQL Server 2005 Sets Record for Data Warehousing Performance on Microsoft Windows
SQL Server 2005 achieved the #1 price/performance result for 3-terabyte TPC-H non-clustered benchmark. This is a record breaking TPC-H three-terabyte benchmark for a database running on Microsoft Windows and an HP Integrity rx8640 Server. The recent TPC-H benchmark study with HP demonstrates how Microsoft SQL Server is able to deliver enterprise scalability and performance, enabling our customers to run large-scale, mission critical applications with the best price/performance. This result is twice that of previous SQL Server benchmarks achieved for the launch of SQL Server 2005, demonstrating that SQL Server continues to push the performance envelope. Furthermore, SQL Server 2005 outperformed the previous best result on Windows with a performance of 60,359 QphH@3TB (queries per hour) compared to the previous record of 37,813 with a much better price/performance of $32.60 compared to $38.00.*

* TPC results as of 5/21/07. HP Integrity rx8640 (with SQL Server), 60359 QphH@3TB, 32.60 $/QphH@3TB, available 5/21/07. HP Integrity rx8640 (with Oracle), 37813 QphH@3TB, 38.00 $/QphH@3TB, available 5/14/07. Source: Transaction Processing Performance Council ( www.tpc.org).

*


SQL Server delivers scalability for e-commerce, data warehousing, and line-of-business solutions.

SQL Server 2005 Powers 93,000 SAP Concurrent Users: 3.5 Times Better than SQL Server 2000
The most recent SAP benchmark shows how SQL Server 2005, Intel, and Hewlett-Packard are ready to support the largest customers worldwide.

TPC-C and TPC-H Benchmark Results for SQL Server Enterprise Edition
Read about record-breaking SQL Server 2005 Enterprise Edition benchmark results from the Transaction Processing Performance Council.

The following tables summarize a selection of SQL Server Enterprise Edition benchmark results for various applications and workloads. To learn more, click the application name for the benchmark. The benchmarks are divided into the following categories: Industry Standard, E-Business, Financial, and Customer Relationship Management.

Industry Standard

Workload/ApplicationResultBest On

TPC-C (nonclustered result)

1,231,433 tpmC

Windows

TPC-H (100 gigabytes)

19,323 QphH

Any platform

TPC-H (300 gigabytes)

18,298 QphH

Windows

TPC-H (1 terabyte)

33,488 QphH

Windows

TPC-H (3 terabytes)

60,359 QphH

Windows

Top of pageTop of page

Line-of-Business Applications

Workload/ApplicationSegmentResultBest On

Great Plains

ERP

1,000 concurrent users

Any platform

SAP APO-DP (2-tier)

ERP

586,319 characteristic combinations per hour

Any platform

SAP R/3 Sales and Distribution (3-tier)

ERP

93,000 concurrent users (32 processors)

Windows

SAP Transaction Banking (3-tier)

Financial

8.279 million postings to bank accounts per hour and 4.27 million balanced accounts per hour

Windows

Siebel eBusiness Application Suite

CRM

30,000 concurrent users

See Siebel site

PeopleSoft Enterprise Applications

CRM
Financials
HCM

25,200 concurrent users
8,955,224 journal lines/hour
82,743 payees/hour

See PeopleSoft site

For more information on Microsoft Windows benchmark results, see Windows Server 2003 Benchmarks.

Top of pageTop of page

Related Links

E.Land Group, Korean Fashion and Discount Retailer, Deploys 4 Terabyte Database on SQL Server 2005

New database benchmark hits enterprise "sweet spot" with Network Appliance, IBM and Microsoft's SQL Server

SQL Server 2005 Is Powering Enterprises Around the World

Windows Server 2003 Benchmarks

Top of pageTop of page

For More Information

Learn more about SQL Server 2005 Enterprise Edition and scalability with these resources:

SQL Server 2005 Enterprise Edition

High Availability
Ensure business continuity with the highest levels of system availability.

Performance and Scalability
Deliver an infrastructure that can grow with your business.

Security
Provide a secure environment to address privacy and compliance requirements.

Manageability
Maintain your infrastructure with automated diagnostics, tuning, and configuration to reduce operational costs.

Business Intelligence
Transform your data into business insight.


Top of pageTop of page