Benchmarks

SQL Server 2012 helps deliver predictable and next-generation performance backed by customer, partner, and industry-leading benchmarks.

SQL Server 2012 is a trusted platform with industry-leading TPC-E benchmark results. TPC Benchmark™ E (TPC-E) measures an On-Line Transaction Processing (OLTP) workload representative of modern customer environments.

OLTP TPC-E Results Published on SQL Server 2012

CompanyMachineResultsPrice/tpsE
NEC Express 5800/A1080a-E4,614450.18 USD
PRIMERGY RX300 S71,871175.57 USD
IBM System x3650 M41,863207.85 USD

Top 3 TPC-E Performance Results

CompanyMachineResult
NEC Express 5800/A1080a-ENew world record: 4,614 tpsE on a Intel Xeon 10-core (80 core) server
IBM System x3850 X54,593 tpsE on a Xeon 8-proc (80-core) server
PRIMERGY RX900 S24,556 tpsE on a Xeon 8-proc (80-core) server
HP ProLiant DL580 G7 Server2,455 tpsE on a Xeon 4-proc (40-core) server

Top 4 OLTP Price / Performance Results

CompanyMachineResult
IBM System x3850 X5130 USD Price/tpsE on a Xeon 4-proc (40-core) server
IBM System x3850 X5141 USD Price/tpsE on a Xeon 8-proc (80-core) server
IBM System x3690 X5143 USD Price/tpsE on a Xeon 2-proc (20-core) server
PRIMERGY RX300 S6 12x2.5184 USD Price/tpsE on a Xeon 2-proc (12-core) server

DW TPC-H Top Results with SQL Server by Size

CompanyMachineResult
HP ProLiant DL380 G773,975 QphH on a Xeon 2-proc (12-core) server
HP ProLiant DL580 G7121,346 QphH on a Xeon 4-proc (32-core) server
HP ProLiant DL980 G7219,888 QphH on a Xeon 8-proc (80-core) server
HP ProLiant DL980 G7162,602 QphH on a Xeon 8-proc (64-core) server
ES7000 Model 7600R80,173 QphH on a Xeon 16-proc (64-core) server

DW TPC-H Top Results Price/Perf by Size

CompanyMachineResult
HP ProLiant DL385 G7.51 USD/QphH on a Opteron 2-proc (24-core) server
HP ProLiant DL580 G7.65 USD/QphH on a Xeon 4-proc (32-core) server
Cisco UCS C460 M2 Server1.30 USD/QphH on a Xeon 4-proc (40-core) server
HP ProLiant DL980 G72.68 USD/QphH on a Xeon 8-proc (64-core) server
ES7000 Model 7600R18.95/QphH on a Xeon 16-proc (64-core) server

“At peak performance, the system processed 11,500 transactions per second in online business testing and averaged more than 10,000 interest accrual and capitalizations per second during close-of-business testing, processing 25 million capitalizations and account accruals in less than 42 minutes.”

Temenos T24 Banking
Solution Brief

New benchmarks published by hardware and software partners on the SQL Server 2012 release further help validate SQL Server as the data platform on which you can bet your business.

Real-World Applications on SQL Server 2012

Application TypeCompany
/ Applications
Result

Insurance Policy Management

Accenture Duck Creek Policy Administration System
9% greater transactional throughput over SQL Server 2008.

At over 37,000 transactions per hour, this Accenture and HP benchmark modeled a mix of complex policy administration activities that a large insurance carrier would expect on a peak day of business processing. Based on data collected from three different Tier 1 insurance carriers, it demonstrates that Microsoft SQL Server 2012 offers a material increase in throughput.

Download the benchmark report to learn more.

Enterprise Software

OpenText ECM Suite
Process 14.8 million email messages in 24 hours.

OpenText, a global ECM leader, helps organizations manage and gain the true value of their business content. During the benchmark study, the OpenText Email Monitoring solution running on SQL Server 2012 processed 14.8 million messages in 24 hours. This far exceeds any known published benchmark results for email monitoring solutions and is approximately 15 times higher than the typical message ingestion volume for large organizations that process 1-1.5 million messages per day.

Read the press release to learn more.

Telecommunications: Billing

Redknee Turnkey Converged Billing (TCB)
Scale to 250 million subscribers.

TCB (Turnkey Converged Billing) built on SQL Server 2012 has been benchmarked to support 250 million subscribers. The 250 million-subscriber test exceeded the performance objectives for both invoicing and mediation, generating 26 million invoices within a six hour billing cycle, and mediating 4.9 billion Call Detail Records (CDRs) within 12 hours, showing a near-linear scalability as the number of subscribers increased.

Download the solution brief to learn more.

Product Lifecycle Management

Siemens Teamcenter
Doubled concurrent users to 10,000 with great performance.

Performance benchmarks conducted by Siemens PLM validate the performance and scalability of Microsoft SQL Server 2012 as an enterprise-class database management system for Teamcenter. The tests confirm that when running on SQL Server 2012, Teamcenter can easily scale to 10,000 concurrent users while maintaining excellent performance.

Download the solution brief to learn more.

Financial Services

Temenos T24
Linear scalability of 95%.

Microsoft SQL Server 2012 along with HP and XIO broke the TEMENOS T24 performance record. At peak performance, the system processed 11,500 transactions per second in online business testing and averaged more than 10,000 interest accrual and capitalizations per second during close-of-business testing, processing 25 million capitalizations and account accruals in less than 42 minutes.

Read the blog to learn more.

Real-World Applications on 2008/2008 R2

Application TypeCompany
/ 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.

Download the Camstar and Microsoft Solution Brief to learn more.

Enterprise Resource Planning

Microsoft Dynamics AX
Record scale improvement of 70% in throughput, scalability, and response time.

Benchmark tests demonstrate that record sale at 50,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.

Download the benchmark report to learn more.

Customer Relationship Management

Microsoft Dynamics CRM
Record scale at 50,000 concurrent users with sub-second response rate.

Benchmark tests demonstrate that record scale at 50,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.

For more information, download Microsoft Dynamics CRM Performance and Scalability with Intel Processor and Solid-State Drive Technologies.

Enterprise Resource Planning

SAP
World record scale set as of February 26, 2008 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 Microsoft study based on a survey of 68 SAP ERP customers shows that Microsoft SQL Server migration can be beneficial to lowering costs for SAP customers. The study shows that "migrating an SAP ERP environment to SQL Server reduced 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 SQL Server for SAP.

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.

Financial Services

Temenos T24
5,203 Transactions Per Second (TPS) from 320 Agents for Interest Capitalization Testing.

Performance benchmark a success for “mission critical” Temenos Banking Application with Microsoft SQL Server 2008 R2 and 8 Socket Intel Xeon Processor 7500 Series-Based Servers.

To learn more, download the benchmark test results., or watch the video.

Enterprise Resource Planning

Infor
Infor ERP LN achieved its highest Baan/LN performance ever on an x86 system.

Infor recently conducted an extensive test of its flagship ERP LN solution (previously known as Baan) on the new HP ProLiant DL980 G7 server, equipped with 8-core Intel Xeon Processors and running Windows Server 2008 R2 and SQL Server 2008 R2 and achieved the highest Baan/LN benchmark ever.

To learn more, download the solution brief, or watch the video.

Product Lifecycle Management

Dassault Systèmes ENOVIA 6
SQL Server 2008 provides an enterprise-class database platform—scaling to 5,000 collaborative users while maintaining performance and meeting user requirements.

Dassault Systèmes and Microsoft ran benchmarking tests to measure performance and scalability for ENOVIA V6 with SQL Server 2008. The benchmarking simulated up to 5,000 collaborative users, SQL Server maintained a consistent average transaction time as the number of users increased.

To learn more, download the benchmark datasheet.

Product Lifecycle Management

PTC Windchill
Benchmark Testing Results: SQL Server Provides Superior Performance for Windchill.

Deploying Windchill 9.1 on Microsoft SQL Server 2005 provides users with a robust database platform, enhancing the performance of Windchill by an average of 10% and delivering on users’ strategic PLM initiatives.

To learn more, download the benchmark whitepaper.

Enterprise Resource Management

Kronos Workforce Central 6.1
SQL Server 2008 is a highly scalable, enterprise ready data platform that provides optimal solution for deploying reliable, highly available, high performance, and secure Workforce Central solutions.

Kronos, with Microsoft, performed three benchmarking studies to demonstrate the market-leading scalability, performance, and cost efficiency of fully integrating Workforce Central version 6.1with Microsoft SQL Server 2008 on Windows Server 2008 R2. These studies also prove that customers can achieve a total cost of ownership (TCO)by running Workforce Central on the Microsoft platform.

To learn more, download the benchmark whitepaper.

“At peak performance, the system processed 11,500 transactions per second in online business testing and averaged more than 10,000 interest accrual and capitalizations per second during close-of-business testing, processing 25 million capitalizations and account accruals in less than 42 minutes.”

Temenos T24 Banking
Solution Brief

The new xVelocity memory optimized column store index feature in SQL Server 2012 delivers breakthrough performance gains for data warehouse queries. SQL Server 2012 is the first mainstream RDBMS to integrate a memory optimized columnar data storage capability into the relational database engine.

To gauge the benefits of xVelocity, Microsoft engineers measured a collection of complex data warehousing queries running with and without ColumnStore Indexes on a large data warehouse.

Microsoft-Tested

Application FeatureVersionResult

Data Warehouse Performance

xVelocity in-memory for data warehousingSQL Server 2012
Gain 10-100x performance in data warehousing queries.

Using a combination of compression, algorithms optimized for modern CPU/memory architectures, and highly parallel execution, xVelocity can speedup query execution times by 4x, 10x, and even 100x, simply by adding column store indexes to the fact tables of a star-schema data warehouse.

Download the xVelocity Benchmark Datasheet to learn more.

ETL Performance (with Unisys)

ETLSQL Server 2008
World record for ETL load performance Load

1TB of data in less than 30 minutes using ETL tools32-proc (64-core) server [ES7000].

Read the to learn more.Download the xVelocity blog to learn more.

“At peak performance, the system processed 11,500 transactions per second in online business testing and averaged more than 10,000 interest accrual and capitalizations per second during close-of-business testing, processing 25 million capitalizations and account accruals in less than 42 minutes.”

Temenos T24 Banking
Solution Brief