Tracking Data count
Stay ahead of BizTalk performance issues by proactively monitoring the number of rows in the TrackingData table with Nodinite. This guide shows you how to set custom thresholds, receive actionable alerts, and optimize your BizTalk environment for reliability and efficiency.
✅ Proactively monitor BizTalk Tracking Data count
✅ Set custom thresholds for alerts
✅ Receive actionable insights to prevent performance issues
✅ Ensure a healthy BizTalk environment with automated monitoring
If the number of rows in the TrackingData table in the BizTalk messagebox remains high over time, it may indicate a performance problem in your BizTalk Server environment. Nodinite helps you identify and resolve these issues before they impact your business.
This image shows the Tracking Data table with a low record count, indicating optimal performance.
Category Name = "Health Check"
Resource Name = "Tracking Data count"
There is additional reading available in the 'TrackingData table growth' user guide.
You may need to modify the content in the following tables if you have moved the BizTalk Server databases to a different SQL Server instance or changed the SQL Instance or database names:
- TDDS_Sources
- TDDS_Destinations
What's being evaluated for 'Tracking Data count'?
Nodinite evaluates the Resource Tracking Data count by comparing the number of rows to your defined thresholds. If the count exceeds these thresholds, the system updates the state accordingly, enabling you to take timely action.
The evaluated states are detailed in the table below:
| State | Status | Description | Actions | |
|---|---|---|---|---|
| Unavailable | Resource not available | Evaluation of the 'BizTalk Table Tracking Data Count' is not possible due to network or security issues | Review prerequisites | |
| Error | Too many rows exist | Number of rows exceeds the configured threshold | Details Edit Metrics chart |
|
| Warning | Too many rows exist | Number of rows exceeds the configured threshold | Details Edit Metrics chart |
|
| OK | Row count within limits | Number of rows within the grace period is less than the configured thresholds | Details Edit Metrics chart |
Tip
From within Nodinite, you can reconfigure the state evaluation at the Resource level using the Expected State feature.
What remote actions are available?
- Details - View the current row count
- Edit - Manage the monitoring thresholds
- Metrics chart - View the metrics chart for the Tracking Data count resource
This image shows the available remote actions for the Tracking Data count resource.
Details
💡View the current row count.
Click the Actions button and select the Details menu item to view the current row count and manage thresholds.
Action menu item for Details.
Next, you can view the current row count the Details modal.
This image shows the Details modal for managing thresholds.
Edit
💡Manage the monitoring thresholds to fit your business needs.
- Grace period before the first alert is sent
- Warning threshold (time in timespan format, e.g., 00:15:00 for 15 minutes)
- Error threshold (time in timespan format, e.g., 00:15:00 for 15 minutes)
- Count based monitoring
- Warning threshold (number of rows)
- Error threshold (number of rows)
This image shows the Edit modal for managing thresholds.
Metrics chart
💡View the metrics chart for the Tracking Data count resource.
Click the Actions button and select the Metrics chart menu item to manage the code behind the Dashboard widget.
This image shows the Metrics chart for Tracking Data count.
Note
The Metrics feature requires the use of the Monitoring Database.