Dell PowerEdge R940 385TB Data Warehouse Fast Track Reference Architecture for - Page 15
Read and write cache, SC Series server object, SC Series volumes
![]() |
View all Dell PowerEdge R940 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 15 highlights
Storage configuration 4.6 4.7 4.8 Creating the custom storage profile, RAID 5 All Tiers Read and write cache Read and write cache were both enabled on the array. SC Series server object The process of mapping a volume to a server object creates the I/O path (or paths) between a volume and a server. When creating a server object, the operating system of the server is defined. The SC Series array includes both single path and multi-path definitions for each version of Windows. In this configuration, the server object on the array was created using the Windows Server 2016 MPIO operating system definition. Since the MPIO version of the Windows 2016 definition was chosen, each volume mapping will contain eight paths. SC Series volumes The Recommended (All Tiers) storage profile is assigned to all volumes, with the exception of the SQL Server data volumes. The SQL Server data volumes use the RAID 5 All Tiers custom storage profile. This uses RAID 5 for the SQL Server data volumes and RAID 10 for all other volumes. None of the volumes were configured to use snapshots. The reference architecture does not include hardware resources to support the use of snapshots. Eight volumes (LUNs) were created to store the SQL Server data files for the data warehouse, with four volumes assigned to each controller. Two volumes were created to store the tempdb data files, with one 15 385TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC PowerEdge R940 and SC9000 | 4032-RA-SQL
![](/manual_guide/products/dell-poweredge-r940-385tb-data-warehouse-fast-track-reference-architecture-microsoft-sql-server-2017-using-emc-sc9000-66a7aa5/15.png)