Cisco Blogs


Cisco Blog > Data Center and Cloud

SQL de Dissabte (SQLSaturday Barcelona)

SQL Saturday Gary and Renee

Of the more than 300 SQLSaturdays around the world, I am lucky enough to represent Cisco at the one in Barcelona on October 25th. If you’re attending TechEd Europe we encourage you to also join us at this one-day free event for IT professionals to learn more about SQL Server and the Cisco Unified Computing System (UCS).

If my experience at a recent SQL event in San Diego is any indication, it is going to be a great event. I was amazed that even after UCS being recognized as the #1 x86 blade server in Americas, many database administrators still came to our table and asked, “What is Cisco doing here at a SQL Saturday event?” The good news is that these same people left with an understanding of how UCS is different from our competitors and can help simplify, standardize and optimize SQL Server deployments.

In San Diego, 80 people showed up to Cisco consulting systems engineer, Aaron Rigney’s presentation, “Optimize Your SQL Server 2014 Workloads with Cisco UCS” which covered the following key benefits.

  • Quickly and easily deploy new SQL Servers in minutes
  • Proactively manage and automate your  SQL Server workloads with Microsoft System Center 2012 R2 and PowerShell integrations with UCS Manager
  • Achieve the highest levels of consolidation and performance for both virtual and bare metal implementations.

Read More »

Tags: , , , , , , , ,

TPC-H Benchmark Establishes Cisco UCS C240 as the Fastest Two-socket Server for Microsoft SQL Server 2014

Cisco (UCS®) continues its tradition of performance and price/performance leadership with the announcement of a world-record TPC-H benchmark at the 1000GB Scale Factor running Microsoft SQL Server 2014. On august 20th 2014, the Cisco UCS® C240 M3 Rack Server delivered the Best Two-Socket Server Performance and Best Overall Price/Performance on the TPC-H Benchmark at the 1000GB Scale Factor.  

The Cisco UCS® C240 M3 Rack Server captured the number-one spot for overall price/performance on the TPC-H benchmark at the 1000GB scale factor with a price/performance ratio of $0.73 USD per QphH@1000 GB and demonstrated 304,362 queries per hour (QphH@1000GB), making it the fastest two-socket server running Microsoft SQL Server 2014.

The TPC-H benchmark evaluates a composite performance metric (QphH@size) and a price/performance metric ($/QphH@size) that measure the performance of various decision support systems by running sets of queries against a standard database under controlled conditions. As tested, the benchmark configuration consisted of a Cisco UCS® C240 M3 Rack Server equipped with 768 GB of memory and two 2 Intel Xeon E5-2690 v2 processors. The system ran Microsoft SQL Server 2014 Enterprise Edition and Windows Server 2012 R2 Standard Edition. Check out the Performance Brief for additional information on the benchmark configuration. The detailed official benchmark disclosure report is available at the TPC Results Highlights Website.

Some of the key highlights of Cisco’s TPC-H Benchmark results are:

Best Price/Performance: The Cisco UCS® C240 M3 Rack Server captured the number-one price/performance spot on the TPC-H benchmark at the 1000-B scale factor with a price/performance ratio of $0.73 USD per QphH@1000GB. This result beats 8-socket HP ProLiant DL980 G7 running Microsoft SQL Server at 219,887 QphH and $ 1.86 USD/QphH@1000GB by 60 percent.

 Best Two-Socket Server Performance for Microsoft SQL Server 2014 Cisco demonstrates 304,362 queries per hour (QphH@1000 GB), making it the fastest two-socket server running Microsoft SQL Server.
LE-46305-PB-TPCH-ForGirish 

Server

Processors (Cores/Threads)

Performance

Price/Performance Ratio

Availability Date

Cisco® UCS C240 M3

2 Intel Xeon E5-2690 3.0 GHz (20   cores, 40 threads in total)

304,362 QphH@1000GB

$0.73 USD per QphH@1000GB

August 20, 2014

HP ProLiant DL980 G7

8 Intel Xeon E7-4870 2.4 GHz (80 cores, 160 threads in total)

219,887 QphH@1000GB

$1.86 USD per QphH@1000GB

August 30, 2011

This result joins the more than 90 previous world-record performance results set by Cisco UCS since it was announced five years ago. Many of these world-record results use real-world workloads, including business applications, Java middleware, database performance, high-performance computing, and virtualized and cloud computing environments. Check out the Cisco UCS Performance Benchmarks website for additional details.

For additional information on Cisco UCS and Cisco UCS solutions please visit Cisco Unified Computing & Servers web page.

Based on TPC-H Benchmark Results as of 8/22/2014.

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

 

Tags: , , , ,