This guide describes the architecture, design principles, configuration best practices, and sizing considerations for the Dell EMC Ready Solution for Microsoft SQL Server 2017. It is intended for database administrators, system engineers, IT managers, system administrators, storage administrators, and architects who design and maintain database infrastructures. Readers should have some knowledge of Microsoft Windows Server, Microsoft SQL Server, VMware virtualization, Dell EMC PowerEdge servers, Dell EMC storage, and Dell EMC networking products.
This guide includes all the setup and configuration details for implementing this two-tier SQL Server solution, including important best practices to enable you to make decisions for tailoring a configuration for your needs. We demonstrate the solution performance by simulating workload against six virtual machines (VMs) with a standard OLTP workload. This guide also provides information about SQL Server data protection using a Data Domain DD6300 appliance for a backup target. The solution uses Dell EMC Data Domain Boost for Enterprise Applications (DDBEA) to perform SQL Server integrated data protection. DDBEA has an enterprise application data-protection framework that uses Data Domain Boost (DD Boost) to integrate the SQL Server native backup application functionality with the Data Domain backup appliance.