6/4/2008 Read this before using bts_CleanupMsgBox stored procedure.

Posted at: 6/4/2008 at 10:37 AM by saravana
Subject: Losing subscriptions after running the sproc, resulting in complete redeploy of BizTalk application(s). bts_CleanupMsgBox is not something new and it's been there from BizTalk 2004 SP1. Basically this script is used to clear the MessageBox database (intended only for development and especially useful while during performance testing). This script is not installed by default, the stored procedure will be empty and does nothing. That's how it should be on a production box, ... [More]
Tags: |  Categories: BizTalk General
Actions: Email this article Email | Kick it! | DZone it! | Save to del.icio.us | Technorati Links
Post Information: Permanent LinkPermalink | CommentsComments(12) | Comments RSS

5/15/2007 Data Tracking and Activity (DTA) Architecture

Posted at: 5/15/2007 at 7:00 PM by saravana
The following picture will tell you all about the DTA architecture in BizTalk server I came across this picture in MSDN (http://msdn2.microsoft.com/en-us/library/aa559554.aspx) , very simple and elegant explanation of DTA architecture. I thought it's worth keeping it for reference. Visit the above link for details about each step. Nandri! Saravana Kumar
Tags: |  Categories: BizTalk General
Actions: Email this article Email | Kick it! | DZone it! | Save to del.icio.us | Technorati Links
Post Information: Permanent LinkPermalink | CommentsComments(0) | Comments RSS

2/20/2007 BizTalk Developers, have you enabled DTA Purge and Archive (BizTalkDTADb) SQL job on your development machine?

Posted at: 2/20/2007 at 6:28 PM by saravana
In development machines, BizTalk developers normally tend to enable full body tracking of messages they process inside the BizTalk server for debugging purpose. As BizTalk Server processes more and more data on your system (over a period of time), the BizTalk Tracking (BizTalkDTADb) database continues to grow in size. Unchecked growth decreases system performance and may generate errors in the Tracking Data Delivery Service (TDDS). In addition to general tracking data, tracked messages can als... [More]
Tags: |  Categories: BizTalk General
Actions: Email this article Email | Kick it! | DZone it! | Save to del.icio.us | Technorati Links
Post Information: Permanent LinkPermalink | CommentsComments(18) | Comments RSS

8/23/2006 Description of SQL Jobs used by Biztalk Server

Posted at: 8/23/2006 at 5:05 PM by saravana
MessageBox_DeadProcesses_Cleanup_BizTalkMsgBoxDb Detects when a BizTalk Server host instance (BTSNTSvc.exe) has stopped responding. The job then releases the work from the host instance so a different host instance can finish the tasks. MessageBox_Message_Cleanup_BizTalkMsgBoxDb Removes all messages that are not referenced by any subscribers in the BizTalk MessageBox (BizTalkMsgBoxDb) database tables. MessageBox_Parts_Cleanup_BizTalkMsgBoxDb Removes all message parts that are no longer ... [More]
Tags:  Categories: BizTalk General
Actions: Email this article Email | Kick it! | DZone it! | Save to del.icio.us | Technorati Links
Post Information: Permanent LinkPermalink | CommentsComments(13) | Comments RSS