Export (0) Print
Expand All

Planning for Database Performance

Microsoft BizTalk Server is an extremely database intensive application that may require the creation of up to 13 separate databases in Microsoft SQL Server. Because of the database intensive nature of BizTalk Server, it is of critical importance that you choose the appropriate version and edition of SQL Server that will house the BizTalk Server databases. To optimize the performance of the computers running SQL Server that house the BizTalk Server databases, follow the recommendations in this topic and in the BizTalk Server Database Optimization white paper (http://go.microsoft.com/fwlink/?LinkID=101578).

BizTalk Server 2010 databases must be installed on either SQL Server 2008 SP1 or SQL Server 2008 R2.

Gg634536.note(en-us,BTS.70).gifNote
While this white paper is written for other versions of BizTalk Server and SQL Server, you can use the same recommendations for BizTalk Server 2010 and SQL Server 2008 SP1 / SQL Server 2008 R2.

BizTalk Server databases should be configured to run on a dedicated SQL Server instance whenever possible. BizTalk Server is a database intensive application, so separation of the BizTalk Server computers and the SQL Server computers that house the BizTalk Server databases will improve performance and should be considered a best practice in a production BizTalk Server environment.

Various editions of SQL Server provide different features which can affect the performance of your BizTalk Server environment. For example, under high-load conditions, the number of available database locks that are available for the 32-bit version of SQL Server may be exceeded, which is detrimental to the performance of the BizTalk solution. Consider housing your MessageBox database on a 64-bit version of SQL Server if you are experiencing "out of lock" errors in your test environment. The number of available locks is significantly higher on the 64-bit version of SQL Server.

Consider the table below when deciding on the database engine features that you will need for your BizTalk environment. For small-scale solutions, for example when running BizTalk Server 2010 Branch Edition, SQL Server 2008 SP1 / SQL Server 2008 R2 Workgroup Edition may be adequate for housing the BizTalk Server databases. For large scale, enterprise-level solutions that require clustering support, BizTalk log shipping support, or Analysis Services support, then you will need SQL Server 2008 SP1 / SQL Server 2008 R2 Enterprise Edition to house the SQL Server databases.

Version and Edition of SQL Server 64-bit support Multi-Instance Support Clustering support Analysis Services

SQL Server 2008 SP1 / SQL Server 2008 R2 Enterprise Edition

Yes

Yes

Yes

Yes

SQL Server 2008 SP1 / SQL Server 2008 R2 Standard Edition

Yes

Yes

Yes (2 node)

Yes

SQL Server 2008 SP1 / SQL Server 2008 R2 Workgroup Edition

Yes

Yes

No

No

Gg634536.note(en-us,BTS.70).gifNote
BAM RTA requires SQL Server 2008 SP1 / SQL Server 2008 R2 Enterprise Edition.

For a complete list of the features supported by the editions of SQL Server 2008 R2, see Features Supported by the Editions of SQL Server 2008 R2 (http://go.microsoft.com/fwlink/?LinkId=151940) in the SQL Server 2008 R2 documentation.

Show:
© 2014 Microsoft