Multiple Instances

Rating:

(0)

Kalen Delaney

SQL Server Magazine

InstantDoc ID #8686

Running multiple SQL Server instances on one machine increases security and reliability

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 ...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

still a worth to read article.

Marcos7/14/2009 10:25:35 AM

what are the steps of doing multiple instance for sql server2000

Mohammed5/5/2004 3:29:05 AM

The article is good and it sheds light on some of the reasons why multiple instances are needed/important. However, I feel that it does not go in sufficient detail regarding the performace of mutliple active instances. For example, if a user starts an extreme resource- intensive query under one instance, then what happens to the performance/throughput/turnaround time for users of OTHER instances? In this case, how does it help to have two/more instances running? Also, I understand that it is easier to give administrative access to Administrators from other organizations (in an ASP setup), but still the ASP needs to retain the control over shared resources (like, disk quota), essentially limiting the "other" Administrator's access to tasks which will not cross the limits set by "ASP" (like running a query/database maintenance/ etc).

- Ravi

Ravindra Kulkarni 6/30/2000 1:14:05 PM

You must log on before posting a comment.

Are you a new visitor? Register Here