October 17, 2008 at 8:44 am
I have just reconfigured my server's memory from SQL Server Management Studio. I have actually reduced our 17GB server and gave 12218MB(previously 16812MB) to SQL and 8126MB(previously 2133MB) to the OS
The thing I am confused about is do I need to reboot the server if I do this?
If not, do we need to reboot the server while increasing the memory?
When I run sp_configure, I could see the changes taking place, but I am not sure does it really take effect without rebooting?
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
October 17, 2008 at 11:34 am
You do not need to reboot the server if you change your memory with the use of this command
Sp_configure 'max server memory',value
GO
Reconfigure with override
October 17, 2008 at 12:23 pm
Thats good to know. But even when I did your way and my way, after running sp_configure to see the changes, they are exactly the same. How can we really be sure that the server has already taken the new configuration.
Either ways, thanks for your script. I will follow yours for my production server so that I don't have to reboot!
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply