May 16, 2012 at 1:18 pm
Can I use the following script to change the max server memory from 24GB to 45GB?
EXEC sp_configure 'Show Advanced Options', 1
GO
RECONFIGURE
GO
EXEC sp_configure
Go
EXEC sp_configure 'max server memory (MB)', 45000
GO
RECONFIGURE
GO
May 16, 2012 at 1:26 pm
sunny.tjk (5/16/2012)
Can I use the following script to change the max server memory from 24GB to 45GB?EXEC sp_configure 'Show Advanced Options', 1
GO
RECONFIGURE
GO
EXEC sp_configure
Go
EXEC sp_configure 'max server memory (MB)', 45000
GO
RECONFIGURE
GO
Probably, I'd actually have to look it up to be sure. I just use SSMS to make the change, simpler.
May 16, 2012 at 1:54 pm
That looks correct. You could change the middle call to only show you the max memory setting so it's easier to see what it was before the change...and then maybe add a call after, like this:
EXEC sp_configure 'Show Advanced Options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'max server memory (MB)'
GO
EXEC sp_configure 'max server memory (MB)', 45000
GO
RECONFIGURE
GO
EXEC sp_configure 'max server memory (MB)'
GO
Either way a message will be printed to tell you the before and after:
Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
Configuration option 'max server memory (MB)' changed from 2147483647 to 45000. Run the RECONFIGURE statement to install.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 16, 2012 at 3:00 pm
Thanks a lot guys.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply