Provides processing information about Rep Agent Sender tasks.
You need not enable any configuration parameters for this monitoring table to collect data.
The columns for monRepSenders are:
Name |
Datatype |
Description |
---|---|---|
DBID |
int |
Unique identifier for the database currently being used by the process. |
SPID |
int |
Session process identifier |
InstanceID |
tinyint |
(Cluster environments only) ID of an instance in a shared-disk cluster. |
EngineBinding |
int |
Number of the engine with which this task is bound (not applicable to threaded mode) |
MessageQueueSize |
int |
Maximum size of the message queue |
MessagesInQueue |
int |
Total number of messages in the message queue |
NumberOfScannerYields |
int |
Total number of times the scanner yielded on a full queue |
NumberOfScannerSleeps |
int |
Total number of times the scanner slept on a full queue |
NumberOfBytesSent |
int |
Total number of bytes sent |
LastRepServerError |
int |
Last error from Replication Server |
NumberOfRetries |
int |
Total number of connection retries |
SleepsOnEmptyQueue |
int |
Total number of sleeps spent on an empty message queue |
NumberOfQueueFlushes |
int |
Total number of times a sender flushed its queue |
SleepTimeOnEmptyQueue |
int |
Total amount of time, in milliseconds, spent sleeping in an empty queue |
LongestSleepTimeOnEmptyQueue |
int |
Longest amount of time, in milliseconds, spent sleeping on an empty queue |
MaxQueueSize |
int |
Maximum queue size ever reached |
DBName |
varchar(30) |
Name of the database in which the task scans |
Dataserver |
varchar(30) |
Dataserver name used to connect to Replication Server |
ReplicationServer |
varchar(30) |
Replication Server name used to connect to Replication Server |
Username |
varchar(30) |
User name used to connect to Replication Server |
Status |
varchar(30) |
Current status of this task |
SleepStatus |
varchar(30) |
Current sleep status, if sleeping |