White Papers

SQL Server 2017 Enterprise Edition configuration
18 65TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC
PowerEdge R640 and Dell EMC PowerVault ME4024 | 3918-RA-SQL
7 SQL Server 2017 Enterprise Edition configuration
7.1 Grant perform volume maintenance task privilege
During installation of SQL Server 2017, the option to grant the SQL Server Database Engine Service the
Perform Volume Maintenance Task privilege was selected.
7.2 SQL Server maximum memory
The maximum server memory for this reference architecture should be set to 864GB which leaves 32GB for
the operating system.
7.3 Max degree of parallelism (MAXDOP)
The max degree of parallelism was set to 0.
For more information, see the Microsoft article, Configure the max degree of parallelism Server Configuration
Option.
7.4 Resource governor
The resource governor was used to limit the maximum memory grant to 12 percent.
For information about the resource governor, see the Microsoft article, Resource Governor.
7.5 Database configuration
The data warehouse database was configured to use multiple file groups, each containing four files
distributed evenly across the four data volumes. All files were allowed to grow automatically. The file groups
were configured with the AUTOGROW_ALL_FILES option to help ensure that all files within a given file
group remain the same size.
7.6 Tempdb configuration
The tempdb database was configured to use eight data files of equal size. The data files were evenly
distributed across the two tempdb data volumes, with four files stored on each volume. The tempdb
transaction log file was placed on the log volume. All files were expanded to the appropriate size and auto
grow was enabled.