Home > Workload Solutions > SQL Server > Guides > Implementation Guide—SQL Server 2019 Best Practices on PowerStore > Physical architecture
This chapter provides information related to architecture design of the solution. Architecture covers different aspects of the solution such as components of physical layer, software layer and Storage volumes design. The architecture was designed to broadly represent the infrastructure that customers use for their SQL databases. Two nodes of Dell PowerEdge R750xs servers were used for the compute layer and a single PowerStore 5000T was used for storage needs.
This two-node architecture is built to provide a high availability design. It can be extended to three or more nodes to consolidate more databases.
The server layer consists of:
Database ESXi servers: Two R750xs PowerEdge servers running ESXi 7.0.3 hypervisors for six VMs running Red Hat Enterprise Linux 8.5 guest operating system. Only one of the two servers is actively used for benchmarking and the second server is reserved for high availability.
Each ESXi server consists of:
The R840 server runs VMware ESXi 7.0.3 as the hypervisor to host multiple VMs including VMware vCenter Server Appliance (VCSA) deployed as a VM and VM windows server 2022 guest operating system installed to run the HammerDB test tool.
The network layer consists of the following types of connectivity:
The networks are implemented with the following switches:
The storage layer consists of the PowerStore T array as the FC SAN storage for databases and the data stores for VM operating system volumes.