FlexPod Datacenter & SQL Server: A Championship Staff Will get Higher!

0
121

[ad_1]

Betting on the GOAT
The date was March 20, 2020.  On that day Superbowl quarterback Tom Brady introduced he would be a part of the Tampa Bay Buccaneers.  Tampa Bay was already a championship caliber workforce, however with Tom becoming a member of the 2021 Superbowl title was all however assured.  The identical may very well be mentioned for a Converged Infrastructure known as FlexPod Datacenter (Cisco Servers with NetApp storage) and the extent of success it has loved internet hosting Microsoft SQL Server over the previous decade.
SQL stays one of many high workloads that clients globally choose FlexPod Datacenter as their system infrastructure to satisfy immediately wants and tomorrow’s challenges.  The compute “participant” on this workforce is a Cisco chassis the 5108 that has housed 5 generations of blade servers (B200 M1 via B200 M5), however on April 6, 2021, a sixth era blade was launched.  The B200 M6 makes use of the third era of Intel® Scalable Xeon™ processors delivering the very best degree of efficiency – similar to Tom Brady!  FlexPod Datacenter – SQL Server with this new participant are all however assured of delivering new ranges of efficiency.  Time for some apply!
Lab vs. the Subject
For Cisco and NetApp, our apply is finished in a Cisco lab versus a soccer discipline.  Within the lab we arrange the newest FlexPod Datacenter design utilizing the brand new B200 M6 blades and a NetApp AFF 800 storage array.  We setup the VMware vSphere ESXi hypervisor and over time we setup every digital machine with a replica of the SQL Server 2019 database and ran some efficiency checks.  One instance, is that this 5 digital machine server characterization.

This graph exhibits how a number of SQL Server digital machines carried out on a single B200 M6 (ESXi) host. As proven, a single SQL Server digital machine delivered about 4700 TPS. As extra SQL Server digital machines had been added to the identical host (scaled to 5 digital machines), the TPS scaled practically linearly as a result of no bottlenecks had been found throughout the Cisco UCS B200 M6 host or within the NetApp A800 storage. With a single SQL Server digital machine workload, about 13.5 p.c of ESXi host CPU utilization was observed. As extra digital machines had been added to the host, CPU utilization of the underlying Cisco UCS B200 M6 host additionally scaled practically linearly.
The graph under exhibits the disk information transfers (IOPS) and latency particulars for the corresponding single-host ESXi check described above. The efficiency numbers had been captured utilizing the Home windows Perfmon instrument on the visitor OS degree. A single SQL Server digital machine delivered practically 27000 IOPS. As extra SQL digital machines had been added to the identical host, the IOPS scaled practically linearly. The write latencies (captured utilizing visitor Perfmon) stayed inside 1.5 milliseconds.

The checks had been repeated with 4 B200 M6 servers within the cluster.  As you might need guessed, the efficiency was superior.  The overall Learn Latency is proven because the yellow line and the Write Latency because the blue line.  For added particulars, please see the whitepaper: Deploy FlexPod Datacenter for Microsoft SQL Server 2019 with VMware 7.0 on Cisco UCS B200 M6 and NetApp ONTAP 9.8
A Robust Chief
Each championship workforce wants an important coach/supervisor, for FlexPod Datacenter we’ve got the Cisco Intersight platform!
The Cisco Intersight cloud-based infrastructure administration platform is delivered as a service with embedded analytics in your Cisco and third-party IT infrastructure. This platform presents an clever degree of administration that permits IT organizations to investigate, simplify, and automate their environments which might be geographical dispersed world wide by a single administration interface pane.
NetApp storage and VMware vSphere Integration with the Cisco Intersight Platform
The Cisco Intersight platform helps the administration and monitoring of third-party infrastructures resembling VMware vSphere clusters and NetApp storage. These third-party units are built-in into the Cisco Intersight platform utilizing a digital equipment known as Cisco Intersight Help.  Particulars on learn how to deploy are within the whitepaper, simply obtain and have a look whereas having fun with the upcoming NBA basketball season.
It’s clear that present FlexPod Datacenter clients ought to look so as to add the B200 M6 server and Cisco Intersight to assist elevate their degree of play throughout the information heart; and, when mixed with the NetApp AFF 800 storage array for SQL Server this workforce will stay at a championship degree for years to come back.
 

Sources: 
For added particulars, please see the whitepaper: Deploy FlexPod Datacenter for Microsoft SQL Server 2019 with VMware 7.0 on Cisco UCS B200 M6 and NetApp ONTAP 9.8

Share:

[ad_2]