monRepLogActivity

Collects information from monitor counters updated by Replication Agent.

Enable the activate monitoring configuration parameters to start collecting data.

Columns

The columns for monRepLogActivity 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
`LogRecordsScanned`	`int`	Total number of log records scanned
`LogRecordsProcessed`	`int`	Total number of log records processed
`NumberOfScans`	`int`	Total number of scans performed
`TotalTimeForLogScans`	`bigint`	Total amount of time the scanner thread used to scan the log
`LongestTimeForLogScans`	`bigint`	Longest time spent on a single scan
`AvgTimeForLogScans`	`bigint`	Average amount of time spent on the log scan
`Updates`	`int`	Total number of updates processed
`Inserts`	`int`	Total number of inserts processed
`Deletes`	`int`	Total number of deletes processed
`StoredProcedures`	`int`	Total number of stored procedures processed
`SQLStatements`	`int`	Total number of SQL statements processed
`DDL`	`int`	Total number of DDL log records processed
`Writetext`	`int`	Total number of Log records processed by writetext commands
`LobColumns`	`int`	Total number of DML log records processed for a table with off- ow, large object columns
`CLRs`	`int`	Total number of CLRs processed
`Checkpoints`	`int`	Total number of checkpoints processed
`BeginTransaction`	`int`	Total number of begin transactions processed
`CommitTransaction`	`int`	Total number of commit transactions processed
`AbortedTransaction`	`int`	Total number of aborted transactions processed
`PreparedTransaction`	`int`	Total number of transactions found in the prepare state
`DelayedCommit`	`int`	Total number of delayed commits processed
`MaintenanceUserTransaction`	`int`	Total number of transactions opened by the maintenance user
`NumberOfLogExtentions`	`int`	Total number of times the RepAgent waited for extensions to transactions
`TotalTimeOfLogExtentions`	`bigint`	Total amount of time, in milliseconds, the RepAgent waited for log extensions
`LongestTimeOfLogExtentions`	`bigint`	Longest amount of time, in milliseconds, the RepAgent waited for log extensions
`AvgTimeOfLogExtentions`	`bigint`	Average amount of time, in milliseconds, the RepAgent waited for log extensions
`NumberOfSchemaFwdLookup`	`int`	Total number of schema forward lookups
`TotalTimeOfSchemaFwdLookup`	`bigint`	Total amount of time, in milliseconds, spent on forward scans
`LongestTimeOfSchemaFwdLookup`	`bigint`	Longest amount of time, in milliseconds, spent on a forward scan
`AvgTimeOfSchemaFwdLookup`	`bigint`	Average amount of time, in milliseconds, spent on forward scans
`NumberOfSchemaBckwLookup`	`int`	Total number of schema backward lookups
`TotalTimeOfSchemaBckwLookup`	`bigint`	Total amount of time spent on schema backward lookups
`LongestTimeOfSchemaBckwLookup`	`bigint`	The longest amount of time, in milliseconds, spent on a backward scan.
`AvgTimeOfSchemaBckwLookup`	`bigint`	Average amount of time, in milliseconds, spent on backward scans
`NumberOfMempoolAllocates`	`int`	Total number of RepAgent pool allocates
`NumberOfMempoolFrees`	`int`	Total number of RepAgent memory pool frees
`MempoolCurrentSize`	`int`	Current size of the RepAgent memory pool
`MempoolHighUsage`	`int`	RepAgent memory pool high usage
`DBName`	`varchar(30)`	Name of the database in which the task scans