Server Instances

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Steve Jones » Server Instances

12 posts, Page 1 of 2

1 2 »»

Server Instances

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Thursday, January 01, 2009 10:39 PM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 8:32 AM
Points: 31,433, Visits: 13,747

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

Jason Shadonix

Posted Friday, January 02, 2009 8:29 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, May 20, 2013 4:06 PM
Points: 1,409, Visits: 2,027

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.

Jason Shadonix
MCTS, SQL 2005

Post #628835

Luke L

Posted Friday, January 02, 2009 9:05 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 9:42 AM
Points: 2,891, Visits: 5,858

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

Steve Jones - SSC Editor

Posted Friday, January 02, 2009 9:49 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 8:32 AM
Points: 31,433, Visits: 13,747

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

Luke L

Posted Friday, January 02, 2009 9:56 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 9:42 AM
Points: 2,891, Visits: 5,858

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

SanjayAttray

Posted Monday, January 05, 2009 11:17 AM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924, Visits: 1,554

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

SanjayAttray

Posted Monday, January 05, 2009 11:21 AM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924, Visits: 1,554

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

Steve Jones - SSC Editor

Posted Monday, January 05, 2009 11:29 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 8:32 AM
Points: 31,433, Visits: 13,747

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

Luke L

Posted Monday, January 05, 2009 11:35 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 9:42 AM
Points: 2,891, Visits: 5,858

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

Steve Jones - SSC Editor

Posted Monday, January 05, 2009 1:11 PM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 8:32 AM
Points: 31,433, Visits: 13,747

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 »

12 posts, Page 1 of 2

1 2 »»

Permissions