United States   Change   |   All Microsoft Sites

Home

Microsoft Home  |  Servers and Tools

SQL Server 2008: Benchmarks

Take advantage of SQL Server 2008’s industry-leading performance and scalability for real-world database workloads with the lowest cost of operation, as verified by Microsoft partners and industry-standard Transaction Processing Performance Council’s TPC benchmarks.

About TPC Benchmarks

  • The Transaction Processing Performance Council (www.tpc.org), a not-for-profit organization, defines transaction processing and database performance benchmarks, such as TPC-E and TPC-H, and disseminates objective performance data based on these benchmarks. TPC benchmarks have extremely stringent requirements, including both reliability and durability tests, and must undergo an independent audit. Council members include most major database vendors and suppliers of server hardware systems.

  • Companies participate in TPC benchmarking to show an objective demonstration of performance and price/performance in a regulated environment, and to apply technologies used in the testing process to produce more robust and scalable software and hardware products. Independent auditors certify benchmark results and file a full disclosure report with TPC.  These reports are available at the TPC website.  TPC benchmarks also measure the price/performance of a system by dividing the total system cost by the performance, measured in transactions per second (tpsE) for TPC-E and queries per hour (QphH) for TPC-H. 

  • The TPC-E benchmark, introduced in February 2007 to measure OLTP performance, is broadly representative of customer workloads.  Unlike its predecessor TPC-C, TPC-E uses a complex but realistic database schema and requires mainstream capabilities such as referential integrity and RAID protected storage. 

  • The TPC-H benchmark is a decision support benchmark. It consists of a suite of business oriented ad-hoc queries and concurrent data modifications. The queries and the data populating the database have been chosen to have broad industry-wide relevance. This benchmark illustrates decision support systems that examine large volumes of data, execute queries with a high degree of complexity, and give answers to critical business questions.

Industry

Application

Company

Result

TPC-E*

NEC

New world record: 1126 tpsE on an Itanium 32-proc (64-core) server (AsAmA2) (1)

1st TPC-E result on 64-way server

Bests the previous record by 70%

TPC-E*

IBM

479 tpsE on a Xeon 4-proc (16-core) server (2)

14% performance gain over SQL Server 2005 and Windows Server 2003

Highest performance for 4-socket servers

TPC-H** (10TB)

HP

1st SQL Server or Windows Server result in 10TB category (3)

63K QphH on an Itanium 32-proc (64-core) server [Superdome]


Source: Transaction Processing Performance Council (www.tpc.org)

(1) Result as of 2/27/08.  NEC Express5800/1320Xf, 1,126 tpsE, 2,771 $/tpsE, available 8/30/08. 

(2) Result as of 2/27/08.  IBM System x3850 M2, 479 tpsE, 1,591 $/tpsE, available 8/30/08.

(3) Results as of 2/27/08.  HP Integrity Superdome, 63,650 QphH@10TB, 38.54 $/QphH@10TB, available 8/30/08.  

 

Partners

Application Type

Company/Application

Result

Manufacturing Execution Systems

Camstar

Record scale at 205 MES and 60% space reduction due to database compression
Record scale at 205 Manufacturing Execution System transactions per second and 60 percent space reduction due to database compression were achieved with Camstar’s MES application, SQL Server 2008 and Windows Server 2008.

Enterprise Resource Planning

Microsoft Dynamics AX

Record scale improvement of 70% in throughput, scalability and response time
Benchmark tests demonstrate record scale showing up to 70 percent improvement in throughput scalability and response time; maximizing performance while minimizing database growth using SQL Server 2008 database compression.  

Customer Relationship Management

Microsoft Dynamics CRM

Record scale at 24,000 concurrent users with sub-second response rate
Benchmark tests demonstrate that record scale at 24,000 concurrent users with sub-second response rate was achieved with Microsoft Dynamics CRM 4.0, SQL Server 2008, and Windows Server 2008 for enterprise-level workload. Learn more

Enterprise Resource Planning

SAP

World Record Scale Set by SQL Server 2008 on SAP Sales and Distribution (SD) Standard Application 3-tier benchmark on 4-Processors Server using Industry Standard Blade servers with 34,000 SAP SD Standard Application Benchmark Users (6)
This latest benchmark demonstrates an increase of throughput of nearly a factor of 3 over the last 4 years with Industry Standard hardware (4) (5). The demonstrated throughput by SQL Server 2008 x64 and Windows Server 2008 x64 running on Industry-Standard hardware is expected to cover scalability needs of at least 97% of all SAP deployments worldwide.

SQL Server remains a low TCO platform for SAP. A study covering 68 SAP/ERP customers unveiled today by an independent firm, Wipro Technologies, shows that "Microsoft SQL Server migration pays big dividends for SAP/ERP customers". The study concludes that "Migrating an SAP/ERP environment to SQL Server can reduce unplanned downtime by over 20%", "cut IT labor costs by nearly 25%," and "cut ongoing software support costs up to 85%". Download study.

Learn more at Microsoft | SAP Customer Information Center.

Product Lifecycle Management

Siemens Teamcenter

Largest benchmark with Siemens for Product Lifecycle Management Applications
Scalability benchmark with 5,000 concurrent users and 50 percent space reduction due to database compression achieved with Siemens Teamcenter 2007, SQL Server 2008 and Windows Server 2008.  Learn more

 

(4) Certification Number 2003039: SAP SD standard R/3 Enterprise 4.70 application benchmark in 3-Tier configuration certified on July 14, 2003 with Number of benchmark users & comp.: 11,200 SD (Sales & Distribution) with an average dialog response time: 1.90 seconds running  Windows 2003 Enterprise Edition SQL Server 2000 on RDBMS database server. Configuration: RDBMS server: HP ProLiant Model DL760 G2, 8-way SMP, Intel Xeon MP, 2.8 GHz, 2 MB L3 cache, 8 GB main memory. For more details, see http://www.sap.com/benchmark.

(5) Certification Number 2005030: SAP SD standard R/3 Enterprise 4.70 application benchmark in 3-Tier configuration certified on June 27, 2005 with Number of benchmark users & comp.: 18,000 SD (Sales & Distribution)  with average dialog response time: 1.87 seconds running Windows Server 2003 Enterprise Edition (64-bit) and SQL Server 2005 (64-bit) on RDBMS server. Configuration: Database server: HP ProLiant DL585, 4-way SMP, Dual-core AMD Opteron  processor Model 875 (2.2 GHz), 128 KB L1 cache, 2 MB L2 cache, 32 GB main memory. For more details, see http://www.sap.com/benchmark.

(6) Certification Number 2008003: SAP SD standard SAP ERP 6.0 (2005)  application benchmark in 3-Tier configuration certified on 02/26/08 with Number of benchmark users & comp.: 34,000 SD (Sales & Distribution) with an average dialog response time: 1.99 seconds  running  Windows Server 2008 Enterprise Edition (64-Bit)  and SQL Server 2008 (64-bit) on RDBMS database server. Hardware configuration of RDBMS server: HP ProLiant BL680c G5, 4 processor/16 core/16 thread Quad-Core Intel Xeon E7340 / 2.40GHz,  64GB RAM. For more details, see http://www.sap.com/benchmark.

 

ETL Performance

Application

Company

Result

ETL Performance

Unisys

Load 1TB of data in less than 30 minutes using ETL tools

32-proc (64-core) server [ES7000]

World record for ETL load performance

Take a closer look

  • © 2008 Microsoft