Dell PowerEdge R640 Deploying the 55TB Data Warehouse Fast Track Reference Arc - Page 21

Set SQL Server maximum memory, 7.3.4 Con the resource governor, New Query, Execute

Get Dell PowerEdge R640 PDF manuals and user guides View all Dell PowerEdge R640 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 21 highlights

Install and configure SQL Server 2017 Enterprise Edition 7.3.3 7.3.4 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. 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. 21 Deploying the 55TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC PowerEdge R640 and Dell EMC PowerVault ME4024 | 4023-CD-SQL

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
Install and configure SQL Server 2017 Enterprise Edition
21
Deploying the 55TB 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.