Dell PowerEdge R940 385TB Data Warehouse Fast Track Reference Architecture for - Page 14

Storage configuration 4.2 I/O ports The FC ports were configured to use two fault domains in virtual port mode. Ports 1 and 2 from each HBA on each controller were put into fault domain 1 and ports 3 and 4 from each HBA on each controller were put into fault domain 2. 4.3 Disk folder All 48 disks were added to the Assigned disk folder. The SC Series distributed spare feature introduced with SCOS 7.3.1 makes all disks active, so none are reserved as dedicated spares. 4.4 Storage type The disk folder storage type defines the page size on the array and how the disks are configured for redundancy (single or dual). The disk folder can be configured to use a 512KB, 2MB (default), or 4MB page. The Assigned disk folder was configured for single redundancy, using a page size of 512KB. The 512KB page size provides the best performance in all-flash configurations. 4.5 SC Series storage profiles The array uses storage profiles to define the RAID level and tiers where the data is stored for a given volume. By default, newly created volumes use the Recommended (All Tiers) storage profile. This storage profile uses RAID 10 for active (writeable) data and RAID 5 for snapshots (replays). To increase capacity, the reference architecture uses RAID 5 for all data stored on the SQL Server data volumes. A custom storage profile named RAID 5 All Tiers was created. SQL Server data volumes on the array use this custom storage profile to ensure that RAID 5 is always used for those volumes. Because the workload is read-only, there is no performance penalty in a RAID 5 configutation for data volumes. All other volumes use the Recommended (All Tiers) storage profile. The RAID 5 stripe width is left at the default setting of 9 Wide (89% Efficient) to maximize capacity on the array. 14 385TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC PowerEdge R940 and SC9000 | 4032-RA-SQL