Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 912262 - Last Review: March 19, 2009 - Revision: 6.0
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
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.
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.
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://kbalertz.com/Feedback.aspx?kbNumber=899000/
)
The Parallelism setting for the instance of SQL Server when you configure BizTalk Server
APPLIES TO
- Microsoft BizTalk Server 2009 Branch
- Microsoft BizTalk Server 2009 Developer
- Microsoft BizTalk Server 2009 Enterprise
- Microsoft BizTalk Server 2009 Standard
- Microsoft BizTalk Server 2006 R2 Branch Edition
- Microsoft BizTalk Server 2006 R2 Developer Edition
- Microsoft BizTalk Server 2006 R2 Enterprise Edition
- Microsoft BizTalk Server 2006 R2 Standard Edition
- Microsoft BizTalk Server 2006 Developer Edition
- Microsoft BizTalk Server 2006 Standard Edition
- Microsoft BizTalk Server 2006 Enterprise Edition
- Microsoft BizTalk Server 2004 Enterprise Edition
- Microsoft BizTalk Server 2004 Developer Edition
- Microsoft BizTalk Server 2004 Partner Edition
- Microsoft BizTalk Server 2004 Standard Edition
- Microsoft SQL Server 2008 Developer
- Microsoft SQL Server 2008 Enterprise
- Microsoft SQL Server 2008 Standard
- Microsoft SQL Server 2008 Web
- Microsoft SQL Server 2008 Workgroup
- Microsoft SQL Server 2008 Express
- Microsoft SQL Server 2008 Express with Advanced Services
- Microsoft SQL Server 2005 Enterprise Edition
- Microsoft SQL Server 2005 Enterprise X64 Edition
- Microsoft SQL Server 2005 Standard Edition
- Microsoft SQL Server 2005 Standard X64 Edition
- Microsoft SQL Server 2005 Workgroup Edition
- Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
- Microsoft SQL Server 2000 Standard Edition
| kbbts kbtshoot kbinfo KB912262 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate