Spool count
Check if the number of rows in the Spool table exceeds user-defined thresholds.
If the number of rows in the Spool table in the BizTalk message box database is high over time, this may indicate a performance-related problem with your BizTalk Server environment.
Here is an example of when the Spool table has a record count below the Monitoring thresholds.
Here is an example of when the Spool table has a record count that exceeds the warning threshold.
- Category Name="Health Check"
- Resource Name="Spool count"
What's being evaluated for 'Spool count'?
If the number of rows exceeds the user-defined thresholds for the Resource Spool count, the state is evaluated accordingly.
The evaluated state is provided in the table below:
| State | Status | Description | Actions | |
|---|---|---|---|---|
| Unavailable | Resource not available | Evaluation of the 'BizTalk Spool Count' is not possible either due to network or security-related problems | Review prerequisites | |
| Error | Too many rows exists | Number of rows exceeds the configured threshold | Details Edit | |
| Warning | Too many rows exists | Number of rows exceeds the configured threshold | Details Edit | |
| OK | Not too many rows exists | number of rows is less than the configured thresholds | Details Edit |
Tip
The evaluated state may be reconfigured using the Expected State functionality on every Resource within Nodinite.
What remote actions are available?
- Details - View the number of rows
- Edit - Manage thresholds
- Metrics chart: Metrics chart - View the statistics for the number of rows over time
Here's an example of the Remote Actions.
Details
Click the Actions button, and then click the Details menu item to view the current row count.
Here's an example of the Details menu item.
- Details - View the number of rows in the Spool table.
Here's an example of Details about the Spool Count and the Monitoring thresholds.
To learn how to manage the Global configuration, please read the Configuration user guide.
Edit thresholds
To manage the Monitoring thresholds, click the Edit menu item in the Actions button.
Here's an example of the Edit menu item.
In the modal, manage the Monitoring thresholds according to your liking.
Here is an example of the Edit thresholds modal for Monitoring the Spool Count.
Metrics chart
Click the Actions button and click on the Metrics chart menu item to manage the code behind for the Dashboard widget.
Here's an example of the Metrics chart menu item.
Important
The use of the metrics feature for the Spool Count, the Monitoring Database is required.
Here's an example of the 'Spool Count' Widget.