August 5, 2010 at 7:06 am
Hi
I have some doubt in memory config.
We have Windows Server 2008 Enterprise 64 Bit & SQL SERVER 2005 64 Bit edition installed
As per Microsoft , There is no need of configure AWE in 64 bit edition
My doubt is that
1 Suppose we have 32 GB RAM & I do not ebnable AWE , SQL SERVER will eat whole memory ?
2 Suppose we have 32 GB RAM & I ebnable AWE (Min 10GB & Max 20 GB ), SQL SERVER will take up to 20 GB memory or will extend up to 32 GB ?
Regards
Ghanshyam
August 5, 2010 at 8:05 am
Even if you configure AWE, it will be ignored in 64 bit environment.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 5, 2010 at 9:35 am
your means , SQL SERVER will consume whole memory configured on WINDOWS Box even if we set max server memory using AWE
Regards
Ghanshyam
August 5, 2010 at 10:47 am
gupta1282 (8/5/2010)
your means , SQL SERVER will consume whole memory configured on WINDOWS Box even if we set max server memory using AWERegards
Ghanshyam
You don't configure MAX MEMORY using AWE, instead using sp_configure. If you set the max memory SQL Server will use at the max that memory, will not exceed it.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 5, 2010 at 12:26 pm
Hi Ghanshyam,
1. Yes
2. 20 GB
AWE is needed only on 32 bit systems.
Thank You,
Best Regards,
SQLBuddy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply