Creating New Databases or Instances of SQL Server

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Eric I am curious about something. At what point would you suggest or consider creating a new instance of SQL Server instead of creating a new database on an existing instance of SQL Server. I have several databases on one instance of SQL Server and was trying to determine if I could gain some performance if I broke them off to their own instance of SQL Server. Then I got to thinking about managability and was wondering what your thoughts were on this.

thanks in advance for your input.

Jim Keown Viking Electric DBA/Data Warehouse Specialist

-- Anonymous, August 15, 2001

Answers

Jim,

You use multiple instances of SQL Server in order to run two different versions of SQL Server simultaneously. You would typically do this to experiment or to upgrade.

You also would run multiple instances of SQL Server in a failover cluster scenario.

You do not run multiple instances for performance reasons.

Hope this helps,

Eric

-- Anonymous, August 21, 2001


Moderation questions? read the FAQ