Dell PowerEdge R640 55TB Data Warehouse Fast Track Reference Architecture for - Page 18

SQL Server 2017 Enterprise Edition configuration 7 SQL Server 2017 Enterprise Edition configuration 7.1 7.2 7.3 7.4 7.5 7.6 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. SQL Server maximum memory The maximum server memory for this reference architecture should be set to 864GB which leaves 32GB for the operating system. 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. 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. 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. 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. 18 55TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC PowerEdge R640 and Dell EMC PowerVault ME4024 | 3918-RA-SQL