In addition to Mike:
- You need to make sure that at least one of your hosts is enabled for tracking. In BizTalk Administrator, in the "Platform Settings", "Hosts", "Select a Host" section and enable tracking (the list of hosts also shows which hosts (hosts) support current tracking).
You can also check if the SQL tracking agent job is running by looking directly in the database
select count(*) from BizTalkMsgBoxDb.dbo.Spool (NOLOCK)
select count(*) from BizTalkDTADb.dbo.Tracking_Parts1 (NOLOCK)
Basically, the coil should be a fairly low number (<10,000) and should return to a static level after a burst of messages, unless your suspended orcs are growing. And new messages should be copied from MessageBox to DtaDb.TrackingParts every minute, so Tracking_Parts1 should grow several records every 60-120 seconds after processing new messages, although they will eventually be cleared / archived according to your archiving / clearing tracking strategy.
In a Dev environment, more is more fun to track, since the HAT (orchestration debugger) will give you more information than the more you track. However, in a PROD environment, you typically want to minimize tracking to improve performance and reduce disk overhead. We simply track one instance, namely: “before processing” at the reception and “after processing” at the sending ports to our partners, and generally nothing at the internal ports and orcs. This allows us to provide sufficient evidence of the data received and sent.
source share