sql server 2008 r2 express- memory usage

Hello all and thank you for your time.

Like exchange 2010 I have come to realize that sql 2008 r2 express uses alot of memory.  
I did  see that if you right click on the server node in management studio that you can allocate "maximum server memory" and there is an AWE otion as well but im unsure based on my brief research is that worth doin on a 64 bit environment.  just to give you a background I have 5 instances on this sql server the majority of the databases are small ranging from 300mb- 1gb I think I have 1 3 gig database in one instance.  I dont know if thats useful information but I want to see if anyone can provide any suggestion as far as max server memory  or if awe is worth enabling.  any KB  articles are welcomed.

Thanks
LVL 1
jrojas1213Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brian BEE Topic Advisor, Independant Technology ProfessionalCommented:
Unless there is another app that is competeing with SQL for memory, you are better off to let SQL manage its own allocation. Search this article for the word "memory".
http://www.simple-talk.com/sql/database-administration/brads-sure-dba-checklist/
0
jrojas1213Author Commented:
Thats what I thought.  the server is using 90% ram and everything appears to be running fine,  no users complaining as of yet about performance.  sql is the big culprit using over a gig of ram.
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
AWE is used only on 32bit OS, so it is useless here.
MSSQL manages its memory automatically - so if it thinks it is better to use much memory, you should allow for it. Only if you know better, e.g. because you need to have 2GB spare or the like, you should limit the memory. Else you will experience performance issues.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

jmoss111Commented:
SQL Express uses 1 gb RAM max. That said I think it will use 1 GB per instance.
0
jrojas1213Author Commented:
while they were similar he did not answer the question about awe and the other part of the answer I found was more substantial

"so if it thinks it is better to use much memory, you should allow for it. Only if you know better, e.g. because you need to have 2GB spare or the like, you should limit the memory. Else you will experience performance issues."
0
Brian BEE Topic Advisor, Independant Technology ProfessionalCommented:
So my answer was that you don't need to worry about AWE and let SQL manage the memory itself. The link I provided explains more details if they wanted to see my reasoning. I took the time to find a helpful resourse that would address the asker's questions.
If the asker does not feel the is deserving of some recognition, we'll just leave it at that.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.