Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

The auto update statistics option, the auto create statistics option, and the Parallelism setting are turned off in the SQL Server database instance that hosts the BizTalk Server BizTalkMsgBoxDB database


View products that this article applies to.

Introduction

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 instance that hosts the Microsoft BizTalk Server BizTalkMsgBoxDB database.

↑ Back to the top


More information

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 instance that hosts the BizTalkMsgBoxDB database.

↑ Back to the top


References

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 The Parallelism setting for the instance of SQL Server when you configure BizTalk Server

↑ Back to the top


Keywords: kbinfo, kbbts, kbtshoot, KB912262

↑ Back to the top

Article Info
Article ID : 912262
Revision : 6
Created on : 3/19/2009
Published on : 3/19/2009
Exists online : False
Views : 228