This document describes best practices when using Dell EMC™ SC Series arrays with Microsoft® SQL Server®.
This document describes best practices for running Microsoft SQL Server (versions 2008 and later) with Dell EMC SC Series arrays. It is intended for database, system, storage administrators, and architects who analyze, design, and maintain database and storage systems.
It covers sizing for SQL Server, validating the storage design, storage setup and configuration, Windows and server setup, and optimizing SQL Server I/O. Topics include I/O performance metrics, write penalty, RAID considerations, SSD use, snapshots, MPIO, partition alignment, memory, compression, and database design.
| Supported SQL Server versions | 2008 and later |
|---|---|
| Connectivity options | 32Gb Fibre Channel and 100Gb iSCSI |
| Default write RAID type | RAID 10 |
| RAID 10 write penalty | 2 I/Os |
Microsoft SQL Server versions 2008 and later.
32Gb Fibre Channel and 100Gb iSCSI.
RAID 10.
At least 24 hours, including the system peak workload.