In a database environment, reducing cost while achieving high performance is important. Infrastructure equipment is inarguably the biggest cost component of a data center, apart from the power and cooling that are required to run the infrastructure. This solution uses server virtualization to consolidate different SQL Server roles and reduce equipment cost and footprint. The solution also balances database performance and resource utilization by optimally assigning the processors, memory, and network bandwidth.
This Ready Solution for SQL Server 2017 provides end-to-end I/O connectivity by using multiple port channels and Virtual Link Trunking (VLT) configurations for LANs. Dell EMC Networking S4048-ON switches provide 10 GbE network connectivity between the compute cluster and the rest of the data center.
In accordance with SQL Server 2017 best practices and Dell EMC infrastructure design principles, each application network is deployed as a separate workload VLAN that is defined in the data-center core network. All the workload VLANs are created as virtual network adapters on the converged virtual switch across four network connections. To provide high availability for network connections, multiple network cards within each server connect to redundant network switches.
Emulex LightPulse LPE31002 FC adapters provide FC connectivity in the host operating system, and the VMs that require in-guest FC connectivity use virtual FC adapters. The Emulex LightPulse host bus adapters (HBAs) are connected to the Connectrix DS-6610B FC switches and then to the Unity 650 All Flash array, forming a highly available, dual-fabric storage area network (SAN) architecture.
The following figure illustrates the network architecture.
Figure 1. Network architecture
Unity 650F storage offers modular expansion to approximately 16 PB of raw SAN capacity with read and write flash solid-state drives (SSDs). By using Dell EMC Unisphere storage management, you can allocate separate volumes for SQL Server data and transaction logs. The Unity 650F array uses high-density SSDs to provide consistent performance and low response times. Further balancing cost and performance are features such as inline compression, deduplication and zero detection.