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 9
Senior IT System EngineerIT ProfessionalAsked:
Who is Participating?
 
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
 
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
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.

All Courses

From novice to tech pro — start learning today.