Combining multiple application database into SQL Express Edition

People,

I'd like to install multiple application into single server but some of the applications has its own SQL Server database requirement.

So like the following:

Scenario #1
App1 - SERVER-VM\SQLDB1
App2 - SERVER-VM\SQLDB2
...
Appn - SERVER-VM\SQLDBn

assuming those application can use SQL Server 2012 Express Edition, can I just install SQL Express Edition and then set multiple DB instances for all of those apps above ?

Or is it better just to deploy it using single SQLDB Instance and then just install multiple DB under the default SQLEXPRESS instance ?
LVL 10
Senior IT System EngineerIT ProfessionalAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Deepak ChauhanSQL Server DBACommented:
SQL server express edition is limited to 1GB memory, so database engine can utilize upto 1 GB memory. You are planning to connect three application so it would be good if you install three instance for each.

However there are lot of pros and cons of multi instance and single instance such as :
Administration overhead
SystemDB management
Memory management.
Backup Management.
security (logins \users) management.

But this is sql server express edition (free version) so cost would not be a constraint. So install multiple instance per application should be good because of 1 GB memory limitation and only 1 socket or 4 core cpu support.
This way you can avoid TempDB contention.

If your databases are very small and you are sure all application and databases can manage within 1 GB memory then single instance would be good. You can manage it easily.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mohammed KhawajaManager - Infrastructure:  Information TechnologyCommented:
I agree with what Deepak has said and I would the following to the list:

1.  Vendor support - do all the applications work with the same level of service pack
2.  Segregation of security - if using one instance, will there be multiple groups requiring sysadmin roles to the server and if so, is this acceptable to the business
3.  Availability - Upgrading/updating one application could result in other applications going down
0
Senior IT System EngineerIT ProfessionalAuthor Commented:
ok, so if I install multiple instances of SQL Express Edition is that going to be working under one same server ?

suppose I got 8 GB of RAM, so the maximum that I can install the SQL Express is 4 isntances, assuming 4 GB goes to the OS. is that correct ?
0
Mohammed KhawajaManager - Infrastructure:  Information TechnologyCommented:
That is correct.  This would result in 4 distinct SQL server instances where you could run each instance with different service packs if you wish.  Also note that during installation, choose named instance installation and not default instance installation.
0
Senior IT System EngineerIT ProfessionalAuthor Commented:
Thanks !
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.