October 13, 2010 at 6:42 am
If add maxim memory to the server or minimum query memory do I need to restart server?
Thank you
October 13, 2010 at 6:51 am
If the parameter is dynamic (no need to restart server), it's listed here:
select *
from sys.configurations
where is_dynamic = 1
-- Gianluca Sartori
October 13, 2010 at 12:02 pm
min and max memory settings are indeed dynamic. use the following query to set these
exec sp_configure 'Show advanced options', '1'
reconfigure
exec sp_configure 'min server memory (MB)', 'valueinMB'
exec sp_configure 'max server memory (MB)', 'valueinMB'
reconfigure
exec sp_configure 'Show advanced options', '0'
reconfigure
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply