This article discusses why the
auto create statistics option and the
auto update statistics option are disabled and the
Max Degree of Parallelism setting is set to
1 in the Microsoft SQL Server 2000 or Microsoft SQL Server 2005 server instance that hosts the Microsoft BizTalk Server 2004
BizTalkMsgBoxDB database or the Microsoft BizTalk Server 2006
BizTalkMsgBoxDB database.
Back to the top
BizTalk Server relies heavily on SQL Server for accurate and rapid data processing. The
auto create statistics option, the
auto update statistic option, and the
Max Degree of Parallelism setting can significantly change the execution plan of a query from one instance of SQL Server to another instance of SQL Server. Therefore, to provide consistent support for all customers, BizTalk Server pre-hints all queries with the best possible search criteria for each query scenario. This behavior enables consistent BizTalk Server to SQL Server interaction. The interaction can be benchmarked and supported by Microsoft regardless of the customer environment.
To enable BizTalk Server to work as intended, the following options are turned off in the
BizTalkMsgBoxDb database:
| • | auto create statistics |
| • | auto update statistics |
Additionally, the
Max Degree of Parallelism setting is set to
1 in the SQL Server 2000 or SQL Server 2005 server instance that hosts the
BizTalkMsgBoxDB database.
Back to the top
For more information about the Parallelism setting in SQL Server 2000 and in BizTalk Server, click the following article number to view the article in the Microsoft Knowledge Base:
899000 (http://support.microsoft.com/kb/899000/)
The Parallelism setting for the instance of SQL Server when you configure BizTalk Server
Back to the top
Help and Support
