Mutiple Instances

  • Guys

    Is there any article on mutiple instance of SQL 2005 listing common services across multiple instance, Advantages or Disadvantages of having multiple instance.

    Any information will be sufficient for me to start

    Amit


    Kindest Regards,

    Amit Lohia

  • The biggest disadvantage of multiple instances is the division of memory as a resource.

    I guess the biggest advantage is consolidation - msdtc and mssearch are common services that I know of.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply