SQL Server Performance Forum – Threads Archive
SQL 2005 Multiple InstancesI want to know the Advantages/Disadvantages of having more than 1 instances in SQL 2005 , in short I want to know the Best practices & recommendations on running multiple instances on one OS
try refer to this article:
http://www.microsoft.com/technet/technetmag/issues/2006/03/SQLQA/default.aspx and look under SQL Server Instances
There aren’t any unless the hardware is beefy enough to sustain 1 or more instances of SQL server, it depends on your business case and the availability of the service. Otherwise for the consolidation purpose its best to have the multiple instances on a server. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.