- 2 minutes to read

Spool count

Check if the number of rows in the Spool table goes above user-defined thresholds

If the number of rows in the Spool table in the BizTalk messagebox continues to be high over time this may be an indication of a performance problem with your BizTalk Server environment.

Spool count ok
Example when Spool table has low record count

Spool count warning
Example when Spool table has record count above warning threshold

Category Name="Health Check"
Resource Name="Spool count"

What's being evaluated for 'Spool count'?

If the number of rows goes above the user-defined thresholds for the Resource Spool count the state is evaluated accordingly.

The evaluated state is provided by the table below:

State Status Description Actions
Unavailable Resource not available If the number of rows can't be evaluated either due to network or security-related problems Review prerequisites
Error Too many rows exists Number of rows are above configured threshold Details
Warning Too many rows exists Number of rows are above configured threshold Details
OK Not too many rows exists number of rows are less than configured thresholds Details

TIP: The evaluated state may be reconfigured using Expected State functionality that exists on every Resource within Nodinite.


What remote actions are available?

  • Details
  • Metrics chart

Actions

Details

  • Details - View number of rows and edit thresholds

Click on the Actions button and click on the Details menu item to view the current row count and manage thresholds.

Details and Edit
Example to manage thresholds

Global configuration is documented in the Configuration user guide.

Metrics chart *

Click on the Actions button and click on the Metrics chart menu item to manage the code behind for the Dashboard widget.

* requires the use of the Monitoring Database


Next Step

Monitor Views
Configuration

Nodinite Microsoft BizTalk Server Monitoring Agent
Suspended instance(s) (resumable)
Suspended instance(s) (not resumable)