Is it possible to use SQL instance shared for multiple application?

Question

Is it possible to use SQL instance shared for multiple application?

bala2

SSCertifiable

Points: 5547
More actions
November 25, 2013 at 7:04 am

#286579

We got a request where users want to create an database for an application. He want to know whether i want to go for share instance or separate instance .
Should they all use the same instance or should every provider use its own named instance?
What is the best way to follow?
Kindly provide you suggestion.
Advance thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

i'd say one server, lots of database, one database per application. that's a typical scenario in the real world, very common.

a whole server instance per company doesn't end up being very scalable, as you end up competing for resources.

it's easy to set up users on a per database basis, and you don't have 400 different maintenance plans,(one for each isntance) if you had 400 applciaitons and wanted one isntance per applcation.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

SQLAssAS SSCertifiable Points: 7246 More actions · Answer 2

bala2 (11/25/2013)
We got a request where users want to create an database for an application. He want to know whether i want to go for share instance or separate instance .
Should they all use the same instance or should every provider use its own named instance?
What is the best way to follow?
Kindly provide you suggestion.
Advance thanks.

Consider the secuity requirements for each application, if for any reason an application has it hard coded to require security admin\system admin over an instance (bad i know but I have seen it) then you would need a seperate instance for this application.