Provides processing information about Rep Agent Sender tasks.
Enable the activate monitoring configuration parameters to start collecting 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 |
NumberOfTruncPointRequested | int | Total number of times RepAgent asked Replication Server for a new truncation point. |
NumberOfTruncPointMoved | int | Total number of times RepAgent moved the secondary truncation point. |
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 |
AvgTruncPointInterval | int | Displays the average time between truncation point requests. This value is an indication of the effectiveness of the trunc point request interval configuration parameter. If trunc point request interval is set correctly, the values of trunc point request interval and AvgTruncPointInterval will be the same. |
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 |