- 3 minutes to read

Orphaned DTA Service Instances

Info

Receive instant alerts and take action when the number of Orphaned DTA Service Instances exceeds your user-defined monitoring threshold.

When the DTA Archive and Purge SQL Server Agent job archives and deletes tracking data from the BizTalk Server Tracking database (BizTalkDTADb), orphaned rows can accumulate in the dta_ServiceInstanceExceptions table. This issue often occurs when a message instance is resumed and then fails again, generating multiple rows with the same uidServiceInstanceId and uidActivityId. If these orphaned DTA service instances are not removed by the DTA Purge and Archive job, the BizTalkDTADb database can grow excessively large.
Orphaned DTA service instances Resource in OK state in a Monitor View filtered on the Health Check category (7.12)
The Orphaned DTA service instances Resource in a Monitor View; it turns Warning or Error when orphaned instances exceed your thresholds.

Category Name = "Health Check"
Resource Name = "Orphaned DTA Service Instances"

What's evaluated for Orphaned DTA Service Instances?

Nodinite evaluates the state of the Resource Orphaned DTA Service Instances based on your user-defined thresholds:

State Status Description Actions
🚫 Unavailable Resource not available Evaluation of the 'BizTalk Orphaned DTA Service Instances' is not possible due to network or security issues Review prerequisites
❌ Error Too many instances exist Number of instances exceeds the configured threshold Details
⚠️ Warning Too many instances exist Number of instances exceeds the configured threshold Details
✅ OK Not too many instances exist Number of instances is below configured thresholds Details

Tip

You can reconfigure the evaluated state using the Expected State feature on every Resource within Nodinite.

What remote actions are available?

  • Details – Show the number of instances and remove orphaned instances.
  • Edit – Manage thresholds (not yet available on Resource level).
  • Metrics chart – Not yet available for this Resource.

The Action menu of a Health Check Resource with Details and Edit under Control Center and Metrics chart under Metrics (7.12)
Example of available Remote Actions. Every Health Check Resource has the same Action menu.

Details

Click the Action button, then select Details to view the orphaned instances and their row count.
Details menu item in the Action menu (7.12)
Example of the Details menu item.

Details modal for Orphaned DTA service instances with the message There are currently no Orphaned DTA Service Instances and the prerequisites for Remove (7.12)
The Details modal when no orphaned instances exist, with an explanation and the prerequisites for the Remove action.

When Orphaned DTA Service Instances exist, click the Actions button in the Details modal and select Remove to set the dtEndTime values for orphaned instances. This enables the DTA Purge and Archive job (SQL Agent job) to clean these rows on the next run.
Actions button
Example with the Actions button.

Click the Remove menu item to initiate the operation.
Remove button

Edit thresholds

Change monitoring thresholds from the Health Check | Misc tab in the Configuration for your Nodinite Microsoft BizTalk Server Monitoring Agent.
If you click the Edit menu item in the Action button, a modal says This view is not available yet for the resource 'Orphaned DTA service instances'.
Edit menu item in the Action menu (7.12)
Example of the Edit menu item.

Edit modal for Orphaned DTA service instances with the message This view is not available yet (7.12)
The Edit modal for Orphaned DTA Service Instances: change the thresholds in the Configuration instead.

Metrics chart

Not yet available for this Resource: the modal says No metrics found for this Resource.

Click the Action button and select Metrics chart.
Metrics chart menu item in the Action menu (7.12)
Example of the Metrics chart menu item.

Metrics for Orphaned DTA service instances with the message No metrics found for this Resource (7.12)
The Metrics chart modal for this Resource.


Next Steps

Configuration

Nodinite Microsoft BizTalk Server Monitoring Agent Monitor Views