Provides information on where the Rep Agent Scanner task is spending its time
The monRepScanners columns 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 |