·
2 min read

SQL Server 2008 Benchmarks

With the launch of SQL Server 2008 today (remember, RTM is still planned for a few months later in Q3 2008) we have just posted a number of record breaking results across industry (TPC-E, TPC-H) and ISV benchmarks. These are really amazing results and the team worked extremely hard to get these published by launch. We posted best performance results for TPC-E and our first ever TPC-H 10TB result. We delivered a record breaking ETL benchmark loading 1TB of data in less than 30min. And finally record breaking ISV benchmarks showing incredible results with SQL Server 2008.

Industry

Application Company Result
TPC-E* NEC New world record: 1126 tpsE on an Itanium 32-proc (64-core) server (AsAmA2) (1)</SUP)< p>

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)</SUP)< p>

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)</SUP)< p>

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

Partners

Application Company Result
Manufacturing Execution Systems CAMSTAR World 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.
Customer Relationship Management Microsoft Dynamics 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.
Product Lifecycle Management SIEMENS Teamcenter World Record scale and 50% pace reduction achieved with Siemens Teamcenter 2007, SQL Server 2008 and Windows Server 2008
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.
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.
Enterprise Resource Planning SAP/HP World Record Scale Set by SQL Server 2008 on 4-Socket Industry Standard Blade servers in 3-tier SAP SD Standard Application Benchmark Test
This latest benchmark demonstrates an increase of throughput of nearly a factor of 3 over the last 4 years with Industry Standard hardware. 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. Learn more

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

http://www.microsoft.com/sqlserver/2008/en/us/benchmarks.aspx