White Papers
Table Of Contents
- 1 Microsoft SQL Server 2017: Data warehousing with improved column-store technology
- 2 Recommended reference architectures
- 3 Hardware components
- 4 Storage configuration
- 5 Server configuration
- 6 Windows Server 2016 configuration
- 7 SQL Server 2017 Enterprise Edition configuration
- 8 Additional considerations for the highly available reference architecture
- 9 DWFT for SQL Server 2017 certification
- 10 Summary
- A Technical support and resources
Storage configuration
15 385TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC
PowerEdge R940 and SC9000 | 4032-RA-SQL
Creating the custom storage profile, RAID 5 All Tiers
4.6 Read and write cache
Read and write cache were both enabled on the array.
4.7 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.
4.8 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