Set SQL Max Memory using SQL Query
This doesn't require restart since SQL 2014
EXEC sp_configure'max server memory (MB)',209714;
GO
RECONFIGURE;
GO
Configuration option 'max server memory (MB)' changed from 25600 to 209714. Run the RECONFIGURE statement to install.
EXEC sp_configure'max server memory (MB)',209714;
GO
RECONFIGURE;
GO
Configuration option 'max server memory (MB)' changed from 25600 to 209714. Run the RECONFIGURE statement to install.
Comments
Post a Comment