• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 588
  • Last Modified:

SQL Express 2008 R2 Maximum RAM per Database?

I have about 8 SQL Express 2005 databases floating around on 8 different servers. I was going to get a SQL 2008 Standrd License but my quote was several thousand dollars. Seven of my databases take up 30-60MB of RAM and one takes 200MB of RAM in the system monitor.

Is the 1GB RAM limit in SQL Express per database or it is for all the databases combined on a server? I'm sure it is a limit for all databases combined but I'd like to make sure.
0
First Last
Asked:
First Last
  • 2
2 Solutions
 
BDoellefeldCommented:
Hi,

The RAM limit is a 1 GB hard limit for all DBs combined.

The limits for 2005 and 2008 are the same.
http://msdn.microsoft.com/en-us/library/ms345154%28SQL.90%29.aspx
0
 
DaveCommented:
Which SQL licence did you ask for. You can licence as CPU licence , or as Server + Client Access Licence. If you have fewer than about 60 users second option is cheaper, otherwise first. Also note "CPU" = chip not core so even if you get latest 6 core server if it only has one CPU thats only one licence...
0
 
DaveCommented:
One more thought. If you have windows  server enterprise you can run multiple virtual standard servers, so you could get rid of boxes.

http://www.windowsitpro.com/article/tips/virtualization-license-rights-for-windows-server-2008.aspx
0
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.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now