SQL Server Optimizations

BizTalk Server is an extremely database intensive application that may require the creation of up to 13 databases in SQL Server. Because one of the primary design goals of BizTalk Server is to ensure that no messages are lost, BizTalk Server persists data to disk with great frequency and furthermore, does so within the context of an MSDTC transaction. Therefore, database performance is paramount to the overall performance of any BizTalk Server solution.

This section describes general methods for maximizing SQL Server performance as well as methods for maximizing database performance that are specific to a BizTalk Server environment. The following links are also good resources:

• BizTalk Server: Recommendations for Installing, Sizing, Deploying, and Maintaining a Solution

• BizTalk Server Performance Optimization Guide

Next steps

• Pre-Configuration Database Optimizations

• Post-Configuration Database Optimizations

• Optimizing Filegroups for the Databases