Friday, September 7, 2007
BizTalk Server Database Optimization document released
A great resource has just been published to support or debunk many of the myths surrounding the configuration of BizTalk databases in a production environment.
Applies To:
- Microsoft BizTalk Server 2006 and BizTalk Server 2006 R2
- Microsoft SQL Server™ 2005 and SQL Server 2000
- BizTalk Server 2004 with SQL Server 2000
- Internet Information Services (IIS) 5.x and 6.x
The article is titled "BizTalk Server Database Optimization" and details techniques for optimizing the infrastructure of a BizTalk Server system. The goal is to increase the throughput and reduce the latency of the system, maximizing performance.
The listed techniques have demonstrated performance gains in throughput (30-300%) and latency reduction (50% or more).
Most of these changed can be scripted and rolled in as part of a general installation process.
All of the techniques in the doc were tested and BizTalk Server performance lab in Redmond.
The document is highly relevant and recommened.
Labels: BizTalk 2004, BizTalk 2006, IIS, SQL Server 2000, SQL Server 2005