United States   Change   |   All Microsoft Sites

Home - SQL Server 2005

Benchmarks

Performance and Scalability: SQL Server 2005 Enterprise Edition Benchmarks

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.

Workload/Application

Segment

Result

Best On

Great Plains

ERP

1,000 concurrent users

Any platform

SAP

ERP

586,319 characteristic combinations per hour
93,000 concurrent users (32 processors) 

Any platform

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.

Product Details