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 tables for monRepScannersTotalTime 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. |
LogRecProcessed |
bigint |
Total number of log records processed by the scanner thread |
BytesPacked |
bigint |
Amount of bytes packed by the scanner thread |
TotalTime |
bigint |
Total amount of time used by the scanner thread |
MRPBootstrapTime |
bigint |
Total amount of time required, in microseconds, to complete the multipath replication bootstrap cycle |
ScanTime |
bigint |
Total amount of time spent scanning |
ProcessTime |
bigint |
Total amount of time spent processing log records |
SchemaLookupsTime |
bigint |
Total amount of time spent looking for an object’s schema in RepAgent cache |
PackTime |
bigint |
Total amount of time spent packing the LTL |
QueueingTime |
bigint |
Total amount of time spent queueing LTL packets |
HashBindingSize |
bigint |
Total number of buckets in the hash binding table holding an object’s binding information |
HashBindingEntries |
bigint |
Total number of objects bound to a path when RepAgent was boot strapped |
HashBindingCollisions |
bigint |
The length of the longest collision chain used in the hash binding table |
YieldsOnFullQueue |
bigint |
Total number of scanner yields on a full queue |
WaitsOnSenderThread |
bigint |
Total number of waits on a sender thread |
WaitTimeOnSenderThread |
bigint |
Total amount of time, in milliseconds, spent waiting on the sender thread |
LongestWaitOnSenderThread |
bigint |
Longest amount of time, in milliseconds, spent waiting on the sender thread |