Welcome to TechNet Blogs Sign in | Join | Help

Data Platform Insider

Official news for Microsoft's Data Platform
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. Learn more

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

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

Posted: Wednesday, February 27, 2008 9:00 AM by francois
Filed under:

Comments

Alexander Gladchenko said:

Спешите регистрироваться на виртуальные доклады ;) http://www.microsoft.com/heroeshappenhere/events/default

# February 27, 2008 9:45 AM

Be geek my friend said:

Hoy repasando algunos blogs que hace tiempo que no he podido ver, me he encontrado con un post sobre

# March 3, 2008 3:17 AM

Be Geek My Friend said:

Hoy repasando algunos blogs que hace tiempo que no he podido ver, me he encontrado con un post sobre

# March 3, 2008 3:17 AM
Anonymous comments are disabled
Page view tracker