Link to home
Start Free TrialLog in
Avatar of First Last
First LastFlag for United States of America

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of BDoellefeld
BDoellefeld
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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...
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial