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 |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2006-01-12 : 11:02:10
|
| Why do people have various instances of SQL Server running on 1 box , why cant we have various databases running for 1 instanceWhats the advantage of multiple instancesThanks |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2006-01-12 : 11:14:39
|
| What do you think advantages of running multiple instances on one server?here is the excerpts from kalen delaney*****SQL Server users have long desired the capability to run multiple installations of SQL Server on one computer. In SQL Server 2000, that capability has become a reality with a feature called multiple instances. This functionality provides benefits across a wide spectrum of SQL Server sites but will be most beneficial in three main areas: application hosting, server consolidation, and technical support.In the evolving arena of application hosting, one site can provide machine resources and administration services for multiple companies. Small companies that don't have the time or resources to manage and maintain their SQL Server implementations might hire another company to host their SQL Server applications. In such a scenario, each company needs full administrative privileges over its data. However, if the host stores each company's data in a separate database on one SQL Server instance, any SQL Server systems administrator (sa) can access any database. Installing each company's data on a separate SQL Server instance gives each company full sa privileges for its own data without access to any other company's data. Also, by separately tuning each server for memory, CPU, or other resource utilization, the hosting company could charge each hosted company based on use of CPU and disk space resources. . . . ***http://www.windowsitpro.com/SQLServer/Article/ArticleID/8686/8686.html |
 |
|
|
|
|
|
|
|
Instances