Provides information on work queues.
You need not enable any configuration parameters for this monitoring table to collect data.
The columns for monWorkloadQueue are:
Name |
Datatype |
Description |
|---|---|---|
InstanceID |
tinyint |
(Cluster environments only) ID of an instance in a shared-disk cluster. |
CurrentLength |
int |
Current number of queued items |
MaxLength |
int |
Maximum number of queued items |
TotalRequests |
int |
Total number of requests |
QueuedRequests |
int |
Total number of requests that waited for another request to finish |
WaitTime |
int |
Amount of time, in milliseconds, requests waited |
Name |
varchar(30) |
Name of the work queue |