monRepLogActivity

Description

Collects information from monitor counters updated by Replication Agent

Columns

The monRepLogActivity columns for 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
MaxHashSchemaSize	int	Maximum size of the hash schema cache
NumberOfSchemasReused	int	Total number of schemas reused
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