Announcing CU3 for Biztalk 2010

  • Article

Announcing CU3 for Biztalk 2010

It is a pleasure to announce the release of CU3 for BizTalk Server 2010 on behalf of the BPD Sustained Engineering group.   

With this CU, we have addressed all known customer issues and included major enhancements in the form of HIPAA 5010 support and perf improvement in tracking.

The primary scope of this CU is around support for HIPAA 5010 In BizTalk 2010.  The updates leverage the enhanced EDI engine in BizTalk 2010, to natively support 5010 schemas and
acknowledgements without having a need to remap at the application level.  The changes in the CU enables usage of 999 functional acknowdgements and 277CA schemas for 5010 Errata.

Currently there are gaps in the inplementation around side by side support for 4010; we will be addressing this in future updates.

I would also like to highlight an interesting find we had around performance during this CU cycle.  It was identified by some of the highly dedicated team of Biztalk consultants in the field

and was quite a feat to repro the problem as it was senstive to the size of the database and the repro environment.  Thanks to the efforts of test engineers and active participation of the

field team in isolating and narrowing down the affected code path.

Changes to TDDS_GetTrackingData stored procedure resulted in perf improvements of over 100% in cases where we had a high number of records in the TrackingData tables. 

The change to the stored proc itself was very trivial but the results are quite impressive. Here is a snapshot of the SQL query plans that shows the gain in performance:

Query Plan Before Fix:

<StmtSimple StatementCompId="6" StatementEstRows="100" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="11.376"
<QueryPlan DegreeOfParallelism="0" MemoryGrant="1024" CachedPlanSize="120" CompileTime="11" CompileCPU="11" CompileMemory="680">
<RelOp AvgRowSize="953" EstimateCPU="8.05306" EstimateIO="0.0112613" EstimateRebinds="0"
EstimateRewinds="0" EstimateRows="100" LogicalOp="TopNSort" NodeId="0" Parallel="false" PhysicalOp="Sort"
EstimatedTotalSubtreeCost="11.376" >

Query Plan After Fix:

<StmtSimple StatementCompId="11" StatementEstRows="100" StatementId="1" StatementOptmLevel="TRIVIAL" StatementSubTreeCost="0.00580374"
<QueryPlan DegreeOfParallelism="0" CachedPlanSize="24" CompileTime="1" CompileCPU="1" CompileMemory="152">
<RelOp AvgRowSize="952" EstimateCPU="0.00001" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="100" LogicalOp="Top"
NodeId="0" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="0.00580374" >

As we start our planning process for the next Cumulative Update we welcome any suggestions you may provide to improve future Cumulative Update projects. 

Please send your suggestions and feedback to sqlsecu@microsoft.com.  Look for information & announcements for upcoming CU4 for BizTalk Server 2010.

This CU is available for download as of 11\30\2011.  The associated cumulative KB article has also been published. 

Customers are directed to contact CSS to access the CU build or obtain the hotfix package through the new self-service feature by clicking on the “Hotfix Download Available” button
found at the top of the KB article.

Look forward to your comments and suggestions.

Thanks

Guru Venkataraman

Senior Program Manager