patternsqlModerate

Should I restart the instance after adjusting Memory Allocation and MAXDOP?

Submitted by: @import:stackexchange-dba·Mar 10, 2026·

Viewed 0 times

aftertherestartadjustinginstancememoryshouldandallocationmaxdop

Problem

As far as I know adjusting Maximum server memory and Max Degree of Parallelism does not require the instance to be restarted. Will new settings always come into effect without restart?

Solution

Both of those server configuration options do not require a restart of the database engine. Running RECONFIGURE will be sufficient in this case.

exec sp_configure 'show advanced options', 1
go
reconfigure
go

exec sp_configure 'max server memory', 12288
go
exec sp_configure 'max degree of parallelism', 4
go

reconfigure
go

-- the new configuration has taken effect

Please see BOL for reference.

Code Snippets

exec sp_configure 'show advanced options', 1
go
reconfigure
go

exec sp_configure 'max server memory', 12288
go
exec sp_configure 'max degree of parallelism', 4
go

reconfigure
go

-- the new configuration has taken effect

Context

StackExchange Database Administrators Q#22359, answer score: 10

Revisions (0)

No revisions yet.