Provides information on where the Rep Agent Scanner task is spending its time
You need not enable any configuration parameters for this monitoring table to collect data.
The columns for monRepScanners are:
Description |
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) |
LogRecordsScanned |
int |
Total number of log records scanned |
LogrecordsProcessed |
int |
Total number of log records processed |
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 |
DBName |
varchar(30) |
Name of the database in which this task scans |
Status |
varchar(30) |
Current task status |
SleepStatus |
varchar(30) |
Current sleep status, if sleeping |
StartMarker |
varchar(30) |
Start marker in the log for this scanner |
EndMarker |
varchar(30) |
End marker in the log for this scanner |
CurrentMarker |
varchar(30) |
Current marker in the log for this scanner |
OldestTransaction |
varchar(30) |
Oldest open transaction |