- 4 minutes to read

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

Spool count and Tracking Data count, each with its Details, Edit, and Metrics chart dialogs, animated walkthrough (7.12)
Animated walkthrough: Spool count, then Tracking Data count, each with its Details (row count and evaluation thresholds), Edit (the thresholds, closed without saving), and Metrics chart.


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.

Tracking Data count Resource in OK state in a Monitor View filtered on the Health Check category (7.12)
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, and how long they have been there, to your defined thresholds. If a threshold is exceeded, 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 and the evaluation thresholds
  • Edit - Manage the monitoring thresholds
  • Metrics chart - View the metrics chart for the Tracking Data count resource

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

Details

Tip

View the current row count.

Click the Action button and select the Details menu item.

Details menu item in the Action menu (7.12)
The Details menu item.

The Details modal shows the Application (the BizTalk Group), the Environment, the current Row count, and the Evaluation thresholds: Age and Count, each with a Warning and an Error value.

Details modal for Tracking Data count with Row count 0 and the Age and Count evaluation thresholds (7.12)
The Details modal for the Tracking Data count.

Edit

Tip

Manage the monitoring thresholds to fit your business needs.

Click the Action button and select the Edit menu item. The Tracking Data Count modal has two sections; click Save to keep your changes:

  • Grace time: the grace period before the first alert is sent
    • Warning time span (timespan format, e.g., 00:15:00 for 15 minutes)
    • Error time span (timespan format, e.g., 00:15:00 for 15 minutes)
  • Count: the minimum number of rows required to trigger an alert
    • Warning count (number of rows)
    • Error count (number of rows)

Tracking Data Count modal with Grace time and Count, each with Warning and Error values, and the Save button (7.12)
The Edit modal for the Tracking Data count thresholds.

Metrics chart

Tip

View the metrics chart for the Tracking Data count resource.

Click the Action button and select the Metrics chart menu item. The modal shows the chart BizTalk Message Box Tracking Data Count with a Time Range (past 15 min, past hour, past day, past week) and the Chart Type. Id, Title, Height, Refresh Interval, and HTML for Dashboard hold the code behind the Dashboard widget.

Metrics chart for Tracking Data count with the BizTalk Message Box Tracking Data Count chart and HTML for Dashboard (7.12)
The Metrics chart for Tracking Data count.

Note

The Metrics feature requires the use of the Monitoring Database.


Next Steps

Monitor Views
Configuration
Spool count

Nodinite Microsoft BizTalk Server Monitoring Agent
Health Check