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 12»»

Server Instances Expand / Collapse
Author
Message
Posted Thursday, January 1, 2009 10:39 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:38 PM
Points: 31,355, Visits: 15,819
Comments posted to this topic are about the item Server Instances






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #628604
Posted Friday, January 2, 2009 8:29 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 10:28 AM
Points: 1,544, Visits: 2,274
Just out of curiosity, anyone ever actually created (or seen) a server with 50 instances of SQL installed on it? Most I've ever done is 6.

The Redneck DBA
Post #628835
Posted Friday, January 2, 2009 9:05 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, November 25, 2014 9:29 AM
Points: 2,655, Visits: 6,016
Interesting... 2 MS docs from the same version of BOL that state different things...

Steve's reference for the question...
http://msdn.microsoft.com/en-us/library/cc645993.aspx

Another with a differing opinion. Doesn't change the answer to this question, but perhaps if we were discussing Std Ed it might. Just odd to see the variations...

http://msdn.microsoft.com/en-us/library/ms143432.aspx

50 instances on a stand-alone server for all SQL Server editions except for Workgroup. Workgroup supports a maximum of 16 instances per computer.

SQL Server supports 25 instances on a failover cluster.


To help us help you read this

For better help with performance problems please read this
Post #628868
Posted Friday, January 2, 2009 9:49 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:38 PM
Points: 31,355, Visits: 15,819
Luke, great link and I've sent a feedback note to the BOL team to correct one of the pages. Not a great question in light of that link.

I have heard of some ASPs using 30-40 instances so they can give SA and Agent to different people, but I'm not sure how effective that is.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #628912
Posted Friday, January 2, 2009 9:56 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, November 25, 2014 9:29 AM
Points: 2,655, Visits: 6,016
I think the question is fine. 50 is the max. for Ent Ed. No question in that. Just whatever Google search I used to answer the question brought me to the other link I posted and thought the explanation part was either spot on or not so much depending on which BOL reference you happened to look at. Who knows which is correct? Certainly not I.

As with previous posters I couldn't think of a reason why you'd need to many, but I could see the App Service Provider angle. I frankly was just surprised it wasn't based on some binary number, cause really what's the difference between 50 and 64?

-Luke.


To help us help you read this

For better help with performance problems please read this
Post #628925
Posted Monday, January 5, 2009 11:17 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: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
Jason Shadonix (1/2/2009)
Just out of curiosity, anyone ever actually created (or seen) a server with 50 instances of SQL installed on it? Most I've ever done is 6.


NO. I had not. Most I ever used is 9 instances on same server 7 SQL Server 2005 and 2 SQL Server 2000.
But I had read some where that most instances you can have on a server is 32.


SQL DBA.
Post #630012
Posted Monday, January 5, 2009 11:21 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: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
I assumed 32 is the max limit but its 50.

http://msdn.microsoft.com/en-us/library/ms143432(SQL.90).aspx

50 instances on a stand-alone server for all SQL Server 2005 editions except for Workgroup Edition. Workgroup Edition supports a maximum of 16 instances.

SQL Server 2005 supports 25 instances on a failover cluster.


SQL DBA.
Post #630014
Posted Monday, January 5, 2009 11:29 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:38 PM
Points: 31,355, Visits: 15,819
There are conflicting entries in BOL on this. One says 50 only on Enterprise, another says this includes Standard. I've submitted feedback to have something corrected.

Unless someone wants to install 49 more times on one of their Standard servers and see if it works.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #630020
Posted Monday, January 5, 2009 11:35 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, November 25, 2014 9:29 AM
Points: 2,655, Visits: 6,016
Sure Steve, let me get right on that one ;)

To help us help you read this

For better help with performance problems please read this
Post #630024
Posted Monday, January 5, 2009 1:11 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:38 PM
Points: 31,355, Visits: 15,819
Talk about a chore. I actually considered it for a second then realized what I was asking.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #630087
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse