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.