[ad_1]
Cisco® C245 M6 Server Powered by 3rd Gen AMD EPYC™ Processor Achieves TPC-H 30TB World Report 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 now have as soon as once more prolonged our dominance in SQL Server primarily based TPC-H outcomes by posting a brand new results of 1,650,000 (QphH)* working SQL Server 2019 for the 30TB TPC-H choice assist benchmark. This result’s 14% increased than HPE’s greatest outcome and 29% higher then Cisco’s earlier posting of 1,278,277 (QphH) posted again in 2020.
Benchmarks are an plain measure of efficiency on a selected workload, the highest result’s the clear winner and no quantity of fancy advertising and marketing messaging can alter these exhausting chilly info! 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 worth. Therefore, exhausting for patrons to see this metric as a bonus both method. Additionally, the variety of processor cores consumed is commonly highlighted as a bonus with the thought being that fewer cores to license SQL Server on the higher. Nonetheless, many enterprise clients have site-wide licenses that present a hard and fast worth not depending on the core rely; and, different clients could possibly be profiting from quite a few different low cost potentialities. As soon as once more, the core rely metric is muted. Uncooked efficiency stays the first metric to think about.
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 principal reminiscence, and (8) 6.4TB Intel Arbordale Plus NVMe Drives to assist to supply one of the best efficiency. As well as, this two-socket server is bodily smaller than the four-socket HPE Superdome Flex 280 Server, in consequence the client can rack and stack extra C245 M6 servers in a normal 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 purposes 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 typically out there launch of what has develop into the preferred relational database by way of buyer installations on the earth as we speak. Microsoft has a protracted historical past relationship again to the preliminary design of the Cisco UCS system launched again in 2009. Over this time, Cisco has maintained a continuing stream of main non-clustered TPC-H outcomes for quite a few variations of SQL Server from 2012 – 2019. You possibly can see for your self on the TPC-H Vesion 2 and Model 3 web site.
The most effective server or system on your group
Rising up, everybody remembers who was the quicker runner at school. How they regarded, the sneakers they used, what shirt they wore, or every other “metric” didn’t matter. The one standards was uncooked efficiency. At present, this is similar standards when figuring out which server or system is greatest on your group, and if you’re your SQL Server primarily based workloads you must take time to think about the AMD primarily based Cisco C245 M6 managed by Cisco Intersight. The time invested might be value it!
* The TPC Benchmark™H (TPC-H) is a choice assist benchmark. It consists of a set of enterprise oriented ad-hoc queries and concurrent information modifications. The queries and the information populating the database have been chosen to have broad industry-wide relevance. This benchmark illustrates choice assist methods that study massive 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 features of the aptitude of the system to course of queries. These features embody the chosen database dimension in opposition to 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:
[ad_2]
