Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How many instances we can create Expand / Collapse
Author
Message
Posted Thursday, March 21, 2013 1:45 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 26, 2014 4:04 AM
Points: 139, Visits: 394
Hi all

I have small doubt, how many instances we can create in production environment

and how many databases we can create on each instance

as per my knowledge we can create only one instance in production environment and also we can create multiple databases

if create multiple instances it will effect on performance on os level or system level

is this correct if anything wrong please correct it
Post #1433615
Posted Thursday, March 21, 2013 2:51 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 7:51 AM
Points: 3,002, Visits: 3,170
Much of the information you need is here http://msdn.microsoft.com/en-gb/library/ms143432(v=sql.105).aspx. Although a lot of this would be dependant on if your hardware could cope with it.

-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question

There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Post #1433639
Posted Thursday, March 21, 2013 3:22 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 26, 2014 4:04 AM
Points: 139, Visits: 394
Thank you very much
Post #1433655
Posted Friday, March 22, 2013 4:29 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 8:41 AM
Points: 15,516, Visits: 27,892
Multiple instances will absolutely affect performance, yes. You just need to monitor your systems to understand how much they will affect it.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1434185
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse