
Cisco Companions with AMD to set a World Document!
Cisco® C245 M6 Server Powered by 3rd Gen AMD EPYC™ Processor Achieves TPC-H 30TB World Document for Microsoft SQL Server 2019
With {industry} server efficiency benchmarks, there’s a “winner” or prime outcome adopted by everybody else. Cisco is happy to announce that we’ve as soon as once more prolonged our dominance in SQL Server based mostly TPC-H outcomes by posting a brand new results of 1,650,000 (QphH)* working SQL Server 2019 for the 30TB TPC-H choice help benchmark. This result’s 14% increased than HPE’s finest outcome and 29% higher then Cisco’s earlier posting of 1,278,277 (QphH) posted again in 2020.
Benchmarks are an simple measure of efficiency on a selected workload, the highest result’s the clear winner and no quantity of fancy advertising messaging can alter these arduous chilly information! This is the reason clients proceed to make use of benchmarks as part of their system choice standards.
Uncooked efficiency
Some distributors will attempt to level to a $$/Kperf benefit however fail to acknowledge that this benefit is diminished ought to the opposing vendor merely present a bigger low cost off checklist value. Therefore, arduous for purchasers to see this metric as a bonus both approach. Additionally, the variety of processor cores consumed is usually highlighted as a bonus with the thought being that fewer cores to license SQL Server on the higher. Nevertheless, many enterprise clients have site-wide licenses that present a hard and fast value not depending on the core depend; and, different clients may very well be profiting from numerous different low cost prospects. As soon as once more, the core depend metric is muted. Uncooked efficiency stays the first metric to contemplate.
The C245 M6 is the most recent two-socket server from Cisco powered by the third Gen AMD EPYC™ Processor household. The system contained (2) AMD EPYC™ 7763 64 Cores @2.5GHz, 280W processors, 8 TB of primary reminiscence, and (8) 6.4TB Intel Arbordale Plus NVMe Drives to assist to offer the most effective efficiency. As well as, this two-socket server is bodily smaller than the four-socket HPE Superdome Flex 280 Server, because of this the client can rack and stack extra C245 M6 servers in a regular 42U rack. Lastly, the C245 M6 is managed by Cisco Intersight™ which is a Software program-as-a-Service (SaaS) hybrid cloud operations platform which delivers clever automation, observability, and optimization to clients for conventional and cloud-native functions and infrastructure.
3rd Gen AMD EPYC Sequence Processors are constructed on the brand new “Zen 3” core and AMD Infinity Structure with 128-160 lanes of industry-leading PCIe® Gen 4 I/O, 7nm x86 CPU expertise, and an built-in safety processor on die. AMD EPYC 7003 CPUs present as much as 32MB of L3 cache per core, 4-6-8 reminiscence channel interleaving designed for higher economies and efficiency in a number of DIMM configurations, plus synchronized clocks between cloth and reminiscence.
SQL Server 2019 is the newest usually obtainable launch of what has turn out to be the preferred relational database by way of buyer installations on the planet at present. Microsoft has an extended historical past courting again to the preliminary design of the Cisco UCS system launched again in 2009. Over this time, Cisco has maintained a relentless stream of main non-clustered TPC-H outcomes for numerous variations of SQL Server from 2012 – 2019. You may see for your self on the TPC-H Vesion 2 and Model 3 web site.
One of the best server or system on your group
Rising up, everybody remembers who was the sooner runner at school. How they seemed, the footwear they used, what shirt they wore, or every other “metric” didn’t matter. The one standards was uncooked efficiency. At the moment, this is similar standards when figuring out which server or system is finest on your group, and in case you are taking a look at your SQL Server based mostly workloads it’s best to take time to contemplate the AMD based mostly Cisco C245 M6 managed by Cisco Intersight. The time invested will likely be price it!
* The TPC Benchmark™H (TPC-H) is a choice help benchmark. It consists of a set of enterprise oriented ad-hoc queries and concurrent information modifications. The queries and the info populating the database have been chosen to have broad industry-wide relevance. This benchmark illustrates choice help programs that study giant volumes of knowledge, execute queries with a excessive diploma of complexity, and provides solutions to essential enterprise questions.
The efficiency metric reported by TPC-H is known as the TPC-H Composite Question-per-Hour Efficiency Metric (QphH@Measurement), and displays a number of points of the aptitude of the system to course of queries. These points embrace the chosen database measurement towards which the queries are executed, the question processing energy when queries are submitted by a single stream, and the question throughput when queries are submitted by a number of concurrent customers. The TPC-H Value/Efficiency metric is expressed as $/QphH@Measurement. http://www.tpc.org/tpch/
Share: