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
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
Last Comment
ASKER
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.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SQL Express uses 1 gb RAM max. That said I think it will use 1 GB per instance.
ASKER
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."
"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."
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.
If the asker does not feel the is deserving of some recognition, we'll just leave it at that.
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
http://www.simple-talk.com/sql/database-administration/brads-sure-dba-checklist/