Do we Require Multiple SQL Server 2005 instances to server BizTalk Server 2006 R2 Application?

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Do we Require Multiple SQL Server 2005 instances to server BizTalk Server 2006 R2 Application?

Viewing 1 reply thread
  • Author
    Posts
    • August 28, 2009 at 2:41 PM #23149
      community-content

        Hi,

        In our organization, we have 3 SQL Server instances on same server created for BizTalk Server 2006 R2 Application.

        ServerA\INS1 has BizTalkMsgBoxDb database

        ServerA\INS2 has BizTalkDTADb database

        ServerA\INS3 has BizTalkMgmtDb and SSODB databases

        I did not understand what is the purpose of creating 3 instances for BizTalk Server 2006 R2 Application? Is the Best Practice from MS? Any performance increase? If yes in what way we achieve the performance improvement?

        Please advice

      • August 29, 2009 at 2:45 PM #23153
        community-content

          Hi,

          There are no performance gains from the type of setup you described at your company.

          You would see an impact on load-balancing, failover and scalability by doing SQL Server clustering on BizTalk installations, and there are plenty of articles and resources on the Internet to help you achieve that.

          Best.

      • Author
        Posts
      Viewing 1 reply thread
      • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.