October 26, 2010 at 11:01 am
do you maybe have the -g flag set to 5.7 in the startup parameters??
October 28, 2010 at 12:18 pm
SQL server take more RAM, if SQL sever need it.
[p]But You can set: [/p]
[p]sp_configure 'max server memory (MB)',6144;[/p]
[p]sp_configure 'min server memory (MB)',6144;[/p]
[p]reconfigure with override[/p]
October 30, 2010 at 2:48 am
nekonecny (10/28/2010)
SQL server take more RAM, if SQL sever need it.[p]But You can set: [/p]
[p]sp_configure 'max server memory (MB)',6144;[/p]
[p]sp_configure 'min server memory (MB)',6144;[/p]
[p]reconfigure with override[/p]
Don't forget you will also need to show\hide advanced options like so
exec sp_configure 'show advanced options', '1'
reconfigure
exec sp_configure 'max server memory (MB)', '6144'
exec sp_configure 'min server memory (MB)', '6144'
reconfigure with override
exec sp_configure 'show advanced options', '0'
reconfigure
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2010 at 9:34 am
@g n 418 :
What is the status of your problem after doing configuration from sp_configure.
November 2, 2010 at 12:06 pm
Doing the configuration with sp_configure or the GUI do not make a difference.
Behaviour is still the same as described in my first posting...
--> After rebooting (OS) / restarting (SQLSErver) drops the 'Target Memory' as described before. Normally 'Target Memory' must be the 'Max memory' configured.
November 2, 2010 at 12:43 pm
did you check your startup parameters? is there a -g in there?
November 2, 2010 at 1:52 pm
No, there is not
Viewing 7 posts - 16 through 21 (of 21 total)
You must be logged in to reply to this topic. Login to reply