SQL 2005 on Windows 2008R2 - Max Memory Setting

[cumpleby]

Hi, i hope somebody can assist. I was just wondering if i can change the Max Memory Setting within SQL while the Server is active or am i best to wait until it is least active? In other words will it drop connections or cause any issues changing the setting while the Databases are in use?

Thanks

Chris

 

[SQLBill]

You should be able to change it at any time....it is one of the configurations that does not require a restart. We have made that change to servers without any issues.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[cumpleby]

Thanks for the response, I made the change and it worked fine while active.

 

[biglebowski]

I read somewhere that it is still recommended to use AWE for SQL even if the OS is 64 bit.

We have two Exony VIM DB servers with Server 2008 and SQL 2005 and have setup AWE ok.

Biglebowskis Razor - with all things being equal if you still can't find the answer have a shave and go down the pub.