Monday, Dec 6, 2021

FlexPod Datacenter and SQL Server: A Champion Team Gets Better!

Betting on the GOATThe date was March 20, 2020.  On that day Superbowl quarterback Tom Brady announced he would join the Tampa Bay Buccaneers.  Tampa ..

title

Betting on the GOAT

The date was March 20, 2020.  On that day Superbowl quarterback Tom Brady announced he would join the Tampa Bay Buccaneers.  Tampa Bay was already a championship caliber team, but with Tom joining the 2021 Superbowl title was all but assured.  The same could be said for a Converged Infrastructure called FlexPod Datacenter (Cisco Servers with NetApp storage) and the level of success it has enjoyed hosting Microsoft SQL Server over the past decade.

SQL remains one of the top workloads that customers globally select FlexPod Datacenter as their system infrastructure to meet today needs and tomorrow’s challenges.  The compute “player” on this team is a Cisco chassis the X5108 that has housed 5 generations of blade servers (B200 M1 thru B200 M5), but on April 6, 2021, a 6th generation blade was introduced.  The B200 M6 uses the 3rd generation of Intel® Scalable Xeon
™
processors delivering the highest level of performance – just like Tom Brady!  FlexPod Datacenter – SQL Server with this new player are all but assured of delivering new levels of performance.  Time for some practice!

Lab vs. the Field

For Cisco and NetApp, our practice is done in a Cisco lab as opposed to a football field.  In the lab we set up the latest FlexPod Datacenter design using the new B200 M6 blades and a NetApp AFF 800 storage array.  We setup the VMware vSphere ESXi hypervisor and over time we setup each virtual machine with a copy of the SQL Server 2019 database and ran some performance tests.  One example, is this 5 virtual machine server characterization.



This graph shows how multiple SQL Server virtual machines performed on a single B200 M6 (ESXi) host. As shown, a single SQL Server virtual machine delivered about 4700 TPS. As more SQL Server virtual machines were added to the same host (scaled to five virtual machines), the TPS scaled nearly linearly because no bottlenecks were discovered within the Cisco UCS B200 M6 host or in the NetApp A800 storage. With a single SQL Server virtual machine workload, about 13.5 percent of ESXi host CPU utilization was noticed. As more virtual machines were added to the host, CPU utilization of the underlying Cisco UCS B200 M6 host also scaled nearly linearly.

The graph below shows the disk data transfers (IOPS) and latency details for the corresponding single-host ESXi test described above. The performance numbers were captured using the Windows Perfmon tool at the guest OS level. A single SQL Server virtual machine delivered nearly 27000 IOPS. As more SQL virtual machines were added to the same host, the IOPS scaled nearly linearly. The write latencies (captured using guest Perfmon) stayed within 1.5 milliseconds.



The tests were repeated with four B200 M6 servers in the cluster.  As you might have guessed, the performance was superior.  The total Read Latency is shown as the yellow line and the Write Latency as the blue line.  For additional details, 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 Strong Leader

Every championship team needs a great coach/manager, for FlexPod Datacenter we have the Cisco Intersight platform!

The Cisco Intersight cloud-based infrastructure management platform is delivered as a service with embedded analytics for your Cisco and third-party IT infrastructure. This platform offers an intelligent level of management that enables IT organizations to analyze, simplify, and automate their environments that are geographical dispersed around the world through a single management interface pane.

NetApp storage and VMware vSphere Integration with the Cisco Intersight Platform

The Cisco Intersight platform supports the management and monitoring of third-party infrastructures such as VMware vSphere clusters and NetApp storage. These third-party devices are integrated into the Cisco Intersight platform using a virtual appliance called Cisco Intersight Assist.  Details on how to deploy are in the whitepaper, just download and take a look while enjoying the upcoming NBA basketball season.

It is clear that current FlexPod Datacenter customers should look to add the B200 M6 server and Cisco Intersight to help raise their level of play within the data center; and, when combined with the NetApp AFF 800 storage array for SQL Server this team will remain at a championship level for years to come.

 


Resources: 

For additional details, 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

-------------------------------

By: John McAbel
Title: FlexPod Datacenter & SQL Server: A Championship Team Gets Better!
Sourced From: blogs.cisco.com/datacenter/flexpod-datacenter-sql-server-a-championship-team-gets-better
Published Date: Mon, 18 Oct 2021 16:00:25 +0000

Read More