SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 AWE allocate memory
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

leodone
Starting Member

30 Posts

Posted - 10/05/2011 :  09:52:27  Show Profile  Reply with Quote
Hello Everyone,

I have AWE enabled on my SQL server 2008 on window server 2008 64 BIT with 24 G of RAM. SQL Server is currently using 6 g of RAM.

Question:
1) is this normal?
2) should I disable AWE?
3) What is the basic amount of RAM each databases use? (We have 7 database on this server)

I thought SQL server releases memory when not in use.

Newbie here.

chris_cs
Posting Yak Master

United Kingdom
223 Posts

Posted - 10/05/2011 :  10:03:10  Show Profile  Reply with Quote
My understanding is AWE only needs to be set for 32 bit systems. You should normally stick with the default memory setting when SQL Server is installed.

SQL Server can then use whatever memory is available to it which is what you want for good performance.

Junior DBA learning the ropes
Go to Top of Page

leodone
Starting Member

30 Posts

Posted - 10/05/2011 :  10:13:16  Show Profile  Reply with Quote
Chris

Thanks

Question - to disable it, do I need to restart the database services once I make that change?
Go to Top of Page

chris_cs
Posting Yak Master

United Kingdom
223 Posts

Posted - 10/05/2011 :  10:19:44  Show Profile  Reply with Quote
Not that I'm aware of.

Junior DBA learning the ropes
Go to Top of Page

lappin
Posting Yak Master

182 Posts

Posted - 10/05/2011 :  10:29:48  Show Profile  Reply with Quote
You can test that you are able to access more RAM by setting the minimum and maximum memory being used, e.g. set min=10GB and max=20GB. Then check usage. 10GB might be a high minimum but if the server is only handling SQL Server then it may not be. Setting a realistic minimum means SQL Server will not have to waste resources claiming more memory as it needs it.

Edited by - lappin on 10/05/2011 10:30:16
Go to Top of Page

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1770 Posts

Posted - 10/06/2011 :  19:29:13  Show Profile  Reply with Quote
Here's the straight poop...
1) You don't need AWE enabled in a 64-bit environment
2) It's okay to set it; you might gain a small performance boost if you do
See: http://blogs.msdn.com/b/psssql/archive/2009/09/11/fun-with-locked-pages-awe-task-manager-and-the-working-set.aspx
3) Changing the AWE Enabled setting requires a service restart

=======================================
Faced with the choice between changing one's mind and proving that there is no need to do so, almost everyone gets busy on the proof. -John Kenneth Galbraith
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 10/07/2011 :  03:05:08  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
AWE enabled is completely and totally ignored on 64-bit. It does nothing, it's essentially a no-op.

Enabling AWE will not have any effects at all on 64-bit. It's locked pages that the blog post says can have a performance improvement (service account added to the lock pages in memory local security permission)

--
Gail Shaw
SQL Server MVP
Go to Top of Page

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1770 Posts

Posted - 10/07/2011 :  13:08:15  Show Profile  Reply with Quote
Well, sure ...if you are going to read the ENTIRE article it's pretty clear thar AWE is a no-op; especially the part where they say that "It is a 'no-op' for 64bit SQL Server systems". But reading the ENTIRE article is tantamount to cheating...

=======================================
Faced with the choice between changing one's mind and proving that there is no need to do so, almost everyone gets busy on the proof. -John Kenneth Galbraith
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000