Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sachinonnet
Starting Member
4 Posts |
 Posted - 2008-05-08 : 06:06:54
|
| Is there any limit on SQL server Multiple Instances? if we require to run 60+ Instances on single machine what will be the minimum hardware requirements. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-05-08 : 10:49:49
|
| You can only get 50 instances of SQL Server on a single computer:http://msdn.microsoft.com/en-us/library/ms143432.aspxYou can also get 12 freshmen into a phone booth, but they will generally not be too happy about it. Same with SQL Server. All 50 instances will be squabbling over the physically limited resources (memory, CPU, disk throughput, etc.) |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-08 : 10:57:07
|
| Not a good idea to run so many instances on single server. you will get big performance hit. |
|
|
|
|
|
|
SQL server Multiple Instances