White Papers

Install and configure SQL Server 2017 Enterprise Edition
21 Deploying the 65TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using
Dell EMC PowerEdge R640 and Dell EMC PowerVault ME4024 | 4023-CD-SQL
7.3.3 Set SQL Server maximum memory
Set the SQL Server maximum memory to 864GB:
1. Click New Query on the toolbar.
2. Enter the following T-SQL commands:
EXECUTE sp_configure 'max server memory (MB)', '884736'
GO
RECONFIGURE
GO
3. Click !Execute on the toolbar.
7.3.4 Configure the resource governor
1. Click New Query on the toolbar.
2. Enter the following T-SQL commands to configure the resource governor to limit memory grants to 12
percent:
ALTER WORKLOAD GROUP [default]
WITH( request_max_memory_grant_percent = 12 )
GO
ALTER RESOURCE GOVERNOR RECONFIGURE;
GO
3. Click !Execute on the toolbar.