Spool count
Check if the number of rows in the Spool table exceeds user-defined thresholds.
A high number of rows in the Spool table within the BizTalk message box database can signal performance issues in your BizTalk Server environment. Nodinite empowers you to monitor this metric proactively, helping you prevent bottlenecks and maintain optimal system health.
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.
The Spool table with a record count below the monitoring thresholds, indicating healthy performance.
The Spool table with a record count exceeding the warning threshold, signaling a potential issue.
- Category Name = "Health Check"
- Resource Name = "Spool count"
What's being evaluated for 'Spool count'?
Nodinite evaluates the Resource Spool 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 Spool 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 |
| ⚠️ Warning | Too many rows exist | Number of rows exceeds the configured threshold | Details Edit |
| ✅ OK | Row count within limits | Number of rows is less than the configured thresholds | Details Edit |
Tip
You can reconfigure the evaluated state using the Expected State feature on every Resource within Nodinite.
What remote actions are available?
- Details - View the number of rows and the evaluation thresholds
- Edit - Manage thresholds
- Metrics chart - View statistics for the number of rows over time
The Action menu offers the same Remote Actions on every Health Check Resource: Details and Edit under Control Center, and Metrics chart under Metrics.
Details
Click the Action button, then select the Details menu item to view the current row count.
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.
The Details modal with the Spool count and the evaluation thresholds.
To learn how to manage the Global configuration, see the Configuration user guide.
Edit thresholds
To manage monitoring thresholds, click the Edit menu item in the Action button.
The Edit menu item.
In the modal, adjust the monitoring thresholds to fit your needs, and click Save:
- Grace time: Warning time span and Error time span. The grace period specifies the duration to last before an alert is generated.
- Count: Warning count and Error count. The minimum number of rows required to trigger an alert.
The Edit modal with the thresholds for the Spool count.
Metrics chart
Click the Action button and select the Metrics chart menu item to view the row count over time.
The Metrics chart menu item.
Important
To use the metrics feature for the Spool Count, the Monitoring Database is required.
The modal shows the chart with Select metrics content, a Time Range (past 15 min, past hour, past day, past week), and the Chart Type. Below the chart, Id, Title, Height, Refresh Interval, and HTML for Dashboard give you the code to show the same chart as a widget on the Dashboard.
The Metrics chart modal for the Spool count.
Next Steps
Monitor Views
Configuration
Tracking Data count
Related Topics
Nodinite Microsoft BizTalk Server Monitoring Agent
Health Check