Useful report released by our partner Infosys showing performance improvements using SQL Server 2005 with BizTalk 2006 instead of SQL Server 2000. I like how they explain the scenario they tested, show the results with BizTalk 2004 and SQL 2000, BizTalk 2006 and SQL 2000, and then BizTalk 2006 and SQL 2005. I also appreciate their commentary as to *why* the BTS06 + SQL05 combo performed better.
One number you'll see a lot here is a 40% improvement in performance with BTS06 + SQL05. You'll find scenarios such as interchange (batch) processing, executing rules from orchestration, atomic transactions, convoys, and more. Don't miss the section on "backlogs" where you see how SQL 2005 significantly improves processing of queued up messages. Good stuff.
Technorati Tags: BizTalk