Up to 50 instances!

Question

Up to 50 instances!

rata tata

SSC Enthusiast

Points: 147
More actions
October 4, 2004 at 2:14 am

#163425

Hi,
SQL 2005 database engine supports Up to 50 instances in Enterprise Edition.
What does this mean? Any useful links related this particular feature? Any explanation from you experts?

Thanks,

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

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

Razvan Socol SSCarpal Tunnel Points: 4811 More actions · Answer 1

This means that you can run up to 50 instances of SQL Server on the same machine; This way, up to 50 separate servers are fighting for the same CPU and memory resources. In SQL Server 2000, this limit was 16 instances. It seems that somebody hit this limit (this seems strange to me) and told MS to raise it, and MS listened to them. In my opinion, this isn't an important improvement, because you shouldn't run that many instances anyway.

For more informations about instances in SQL Server 2000, see:

http://msdn.microsoft.com/library/en-us/instsql/in_runsetup_2xmb.asp

Razvan

rata tata SSC Enthusiast Points: 147 More actions · Answer 2

That link was exactly what I was searching for, you heal my breast man.Thanks a million.

Razvan Socol SSCarpal Tunnel Points: 4811 More actions · Answer 3

If you are interested to read why others think that multiple instances can be a good thing, read:

http://www.winnetmag.com/SQLServer/Article/ArticleID/8686/8686.html

Razvan