Benchmarks

Microsoft SQL Server 2008 R2 is setting records for performance and price/performance on industry-standard benchmarks, offering more hardware choices, and displaying leadership in the TPC-E category.




TPC-E Results Published on SQL Server 2008 R2
SponsorsSystemPerf(tpsE)Price
/tpsE
System AvailabilityProcs/Cores
/Threads
CPU Type
IBM System x3850 X54,593140.56 USD8/26/20118 / 80 / 160Intel Xeon E7-8870 2.40GHz
PRIMERGY RX900 S24,556217.27 USD7/1/20118 / 80 / 160Intel Xeon E7-8870 2.40GHz
NEC Express5800/ A1080a-E4,201287.42 USD8/31/20118 / 80 / 160Intel Xeon Processor E7-8870 2.40GHz
HP ProLiant DL580 G7 Server2,455291.00 USD6/20/20114 / 40 / 80Intel Xeon E7-4870 2.40GHz
Unisys ES7000 Model 7600R G2 Enterprise Server 4s2,023382.33 USD7/30/20104 / 32 / 64Intel Xeon X7560 2.26GHz
Dell PowerEdge R9101,933297.44 USD 5/6/20104 / 32 / 64 Intel Xeon-Quad Core x7560 2.27GHz
OLTP Performance:
TPC-E**
CompanyMachineResult
IBM System x3850 X5New world record: 4,593 tpsE on a Xeon 8-proc (80-core) server
PRIMERGY RX900 S24,556 tpsE on a Xeon 8-proc (80-core) server
PRIMEQUEST 1800E24,415 tpsE on a Xeon 8-proc (80-core) server
OLTP Price / Performance:
TPC-E**
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 Performance*: TPC-H
CompanyMachineResult

(100 GB)
HP ProLiant DL380 G773,975 QphH on a Xeon 2-proc (12-core) server

(300 GB)
HP ProLiant DL580 G7121,346 QphH on a Xeon 4-proc (32-core) server

(1,000 GB)
HP ProLiant DL980 G7229,888 QphH on a Xeon 8-proc (80-core) server

(3,000 GB)
HP ProLiant DL980 G7162,602 QphH on a Xeon 8-proc (64-core) server

(10,000 GB)
ES7000 Model 7600R80,173 QphH on a Xeon 16-proc (64-core) server
DW Price / Performance*: TPC-H
CompanyMachineResult

(100 GB)
HP ProLiant DL385 G7.51 USD/QphH on a Opteron 2-proc (24-core) server

(300 GB)
HP ProLiant DL580 G7.65 USD/QphH on a Xeon 4-proc (32-core) server

HP (1,000 GB)
IBM System x3850 X5 8P1.37 USD/QphH on a Xeon 8-proc (80-core) server

(3,000 GB)
HP ProLiant DL980 G72.68 USD/QphH on a Xeon 8-proc (64-core) server

(10,000 GB)
ES7000 Model 7600R18.95/QphH on a Xeon 16-proc (64-core) server
ETL Performance
ApplicationCompanyResult
ETL PerformanceWorld record for ETL load performanceLoad
1TB of data in less than 30 minutes using ETL tools
32-proc (64-core) server [ES7000]
ISV Performance
& Scalability
Application
Type
Company/ApplicationResult
Manufacturing Execution SystemsCamstarRecord 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 PlanningMicrosoft Dynamics AXRecord 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 ManagementMicrosoft Dynamics CRMRecord 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 PlanningSAPWorld 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 ManagementSiemens TeamcenterLargest 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.
Mission-Critical Application PerformanceTemenos T245,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 PlanningInforInfor 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 and Infor EAM Benchmark Results report.
Product Lifecycle ManagementDassault Systèmes ENOVIA 6SQL 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 ManagementPTC WindchillBenchmark 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 ManagementKronos Workforce Central 6.1SQL 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.

(1) Certification Number 2008003: SAP SD Standard SAP ERP 6.0 (2005) application benchmark in 3-Tier configuration certified on February 26, 2008, with Number of benchmark users & comp.: 34,000 SD (Sales & Distribution) with an average dialog response time: 1.99 seconds running Windows 2008 Enterprise Edition SQL Server 2008 Enterprise Edition on RDBMS database server. Configuration: RDBMS server: HP ProLiant BL680c G5, 4 processors / 16 cores / 16 threads, Quad-Core Intel Xeon Processor E7340 2.4 GHz, 64 KB L1 cache per core and 4 MB L2 cache per 2 cores, 64 GB main memory. For more details, see http://www.sap.com/benchmark.




Site Map

  • Find Us
  • Facebook Twitter YouTube
  • MTNL/BSNL Toll free number: 1800 11 11 00
    Bharti Toll %free number: 1800 102 1100
    Toll number: +91 80 40103000