• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 585
  • 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.
First Last
First Last
  • 2
2 Solutions

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

The limits for 2005 and 2008 are the same.
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...
One more thought. If you have windows  server enterprise you can run multiple virtual standard servers, so you could get rid of boxes.

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

WEBINAR: GDPR Implemented - Tips & Lessons Learned

Join the WatchGuard team on Thursday, March 29th as we recount some valuable lessons learned in weighing the needs of a business against the new regulatory environment, look ahead at the two months left before implementation, and help you understand the steps you can take today!

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