August 14, 2009 at 8:29 am
Hi there
I just want to double check I have got the settings correct for memory:
Server:
sql 2005 stan (x64)
windows 2003 sp2 (x64)
I have 32GB of RAM
I configured the max server memory (sp_configure) to 32768 (might bring that down a bit)
and I set AWE enabled = on.
Will it use more than the default 2gb now? or is there anything else I need to configure?
August 14, 2009 at 8:32 am
You don't need to worry about the AWE for 64 bit. It's basically ignored as the memory can be directly accessed.
August 14, 2009 at 8:35 am
Ok, does it matter that I have turned it on?
August 14, 2009 at 8:38 am
No, it's just basically ignored. I just noted for you reference so you don't worry about it in the future.
http://msdn.microsoft.com/en-us/library/ms190673(SQL.90).aspx
August 14, 2009 at 8:42 am
Thanks very much for your help 🙂
August 14, 2009 at 2:33 pm
Better reduce the max server memory limit.
MJ
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply