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

Storage configuration volume assigned to each controller. If the volumes are created and mapped to the server, one right after the other, the array should automatically distribute the volumes evenly across the controllers. Otherwise, the controller can be manually selected using the advanced options when mapping the volume to the server. To achieve optimal results, the SQL Server data and tempdb volumes must be evenly distributed across the controllers. SC Series volumes created for the reference architecture Volume name Storage profile Volume purpose DWFT-4S - MPHost Recommended (All Tiers) Mount point host DWFT-4S - SQLSystem Recommended (All Tiers) SQL Server system databases and files DWFT-4S - SQLLog Recommended (All Tiers) Transaction log files for tempdb and the data warehouse DWFT-4S - SQLData01 RAID 5 All Tiers Data files for the data warehouse DWFT-4S - SQLData02 RAID 5 All Tiers Data files for the data warehouse DWFT-4S - SQLData03 RAID 5 All Tiers Data files for the data warehouse DWFT-4S - SQLData04 RAID 5 All Tiers Data files for the data warehouse DWFT-4S - SQLData05 RAID 5 All Tiers Data files for the data warehouse DWFT-4S - SQLData06 RAID 5 All Tiers Data files for the data warehouse DWFT-4S - SQLData07 RAID 5 All Tiers Data files for the data warehouse DWFT-4S - SQLData08 RAID 5 All Tiers Data files for the data warehouse DWFT-4S - SQLTempdb01 Recommended (All Tiers) Data files for tempdb DWFT-4S - SQLTempdb02 Recommended (All Tiers) Data files for tempdb 16 385TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC PowerEdge R940 and SC9000 | 4032-RA-SQL