sql server sql express

kerstep1
kerstep1 used Ask the Experts™
on
This might be a simple question
how many separate open databases can sql express handle on one server at a time
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Éric MoreauSenior .Net Consultant
Top Expert 2016

Commented:
I can't remember having seen a limit on the number of databases. Each database is maxed out at 10 gb.
"Batchelor", Developer and EE Topic Advisor
Top Expert 2015
Commented:
AFAIK there is no limit to the number of open databases. The amount of available memory is a constraint, though, since 2012 Express only uses up to 1GB.
For a comparison of available features see
http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx
Éric MoreauSenior .Net Consultant
Top Expert 2016

Commented:
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
its for a small estate agent where they run act 2013 and cfp both on separate win 7 boxes, i wanted to put them both on to one member server, about 25 users
Éric MoreauSenior .Net Consultant
Top Expert 2016

Commented:
no problem

Author

Commented:
i would probably use server 2008 r2 then hypervisor then server standard 2008 again (1 +1) loading sql express 2012 in it
so no probs loading multiple separate instances with express ?
Éric MoreauSenior .Net Consultant
Top Expert 2016

Commented:
Why would you create multiple instances? Just need to create multiple databases in the same instance

Author

Commented:
yes i meant that, so am I correct with the hyper-v idea
Éric MoreauSenior .Net Consultant
Top Expert 2016

Commented:
I hope you don't want to run 25 hyper-V sessions on a small server? Running 25 users on one hyper-V session running SQL Server Express is fine.

Author

Commented:
no, there are 25 users, sorry if I didn't make myself clear
Éric MoreauSenior .Net Consultant
Top Expert 2016

Commented:
Running 25 users on one hyper-V session running SQL Server Express is fine.

Author

Commented:
Would the cheapest way would be server 208 r2 standard, the client already has an SBS 2008 server which is running very slow as it's running sql exp studio 2005 for the ACT 2012.
The server is limited to a max of 8gb ram is now having a hard time that why I wanted to separate  rge sql onto a new member server
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
That's a good idea, and should help much. You should try to remove anything non-SBS from that server, as SBS itself with all the available services is a RAM hog. MSSQL gets slower if it can't aquire enough buffer memory to keep frequently used data in memory.

Author

Commented:
so is it 2008r2 or is 2012 better ?
Mike LazarusAct! Evangelist - CRM Consultant

Commented:
Act! 2012 should use SQL 2008 ... Express if you don't have SQL Standard (or better)

But, you said it's SBS - that means Exchange, which will take all the RAM it can

Also, you said there's an 8GB limit ... what's that limit from?
Plus, what drive sub-system are you using? Faster drives will make a great difference in SQL

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial