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.
This image shows the Spool table with a record count below the monitoring thresholds, indicating healthy performance.
This image shows 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 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 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
- Edit - Manage thresholds
- Metrics chart: Metrics chart - View statistics for the number of rows over time
This image shows the available Remote Actions.
Details
Click the Actions button, then select the Details menu item to view the current row count.
This image shows the Details menu item.
- Details - View the number of rows in the Spool table.
This image shows the Details modal with Spool Count and monitoring 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 Actions button.
This image shows the Edit menu item.
In the modal, adjust the monitoring thresholds to fit your needs.
This image shows the Edit thresholds modal for monitoring the Spool Count.
Metrics chart
Click the Actions button and select the Metrics chart menu item to view statistics in the Dashboard widget.
This image shows the Metrics chart menu item.
Important
To use the metrics feature for the Spool Count, the Monitoring Database is required.
This image shows the 'Spool Count' Widget.