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. Populated only when the single task scanning of a log model is used. When the Multiple Replication Paths (MRP) model is used, NumberOfTruncPointRequested values are 0. The monRepSenders table contains related information for the MRP model. |
|
NumberOfTruncPointMoved |
int |
Total number of times RepAgent moved the secondary truncation point Populated only when the single task scanning of a log model is used. When the Multiple Replication Paths (MRP) model is used, NumberOfTruncPointMoved values are 0. The monRepSenders table contains related information for the MRP model. |
|
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 |
|
LogPagesLeft |
int |
The number of remaining log pages to be scanned for this scanner, from its CurrentMarker to the end of the log. |
|
GetLogPageCount |
int |
Controls the retrieval of data for the LogPagesLeft column. The LogPagesLeft column is populated only if the value of GetLogPageCount is 1. |