Provides information on where the Rep Agent Scanner task is spending its time
Enable the activate monitoring configuration parameters to start collecting 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 |
BootstrapTime |
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 |