Home > Workload Solutions > SQL Server > Guides > Design Guide—Modernize Your Microsoft SQL Server Platform and Accelerate Deployments > Summary
The optimized Microsoft SQL Server platform provides a validated solution for SQL Server customers that maximizes flexibility in design and robustness. It was vigorously tested with simulated SQL Server OLTP workloads to ensure all hardware and software are working according to best practices. This validated design was purposely built for SQL Server databases. This allows customers to speed up the deployment of an SQL Server database infrastructure in less time. This design guide also provides customers with a set of initial guidelines to deploy and configure each layer of this SQL Server deployment. Without a validated solution, customers are required to procure the necessary hardware and perform their own tests to ensure all layers are working seamlessly together. This validated design provides a simple starting point for deploying SQL Server database workloads that otherwise would be complex and time-consuming.
This validated design consists of Dell’s state of the art PowerEdge R750 servers, PowerSwitch S5224F-ON, and a PowerStore 1000T storage system. This provides an optimized and robust infrastructure for SQL Server databases.
The PowerEdge R750 is a 2U dual-socket rack server that can be configured with various processor types. Whether it is a bare metal or virtualized deployment, you can configure the PowerEdge R750 to handle the required workloads.
The PowerSwitch S5224F-ON has 24 x SFP28 ports and 4 x QSFP28 ports and provides plenty of network bandwidth for both data networks and uplinks.
The PowerStore is a 2U two-node dual socket Intel® Xeon® platform that has features such as volume groups and snapshots that are required for SQL Server database deployments. The volume group feature allows database snapshot consistency you can use for cloning and near-line backups.