Use Counters to Monitor RepAgent Performance

Adaptive Server provides several counters for monitoring RepAgent performance. You can monitor RepAgent performance data using sp_sysmon.

Invoking sp_sysmon clears all accumulated data from the set of counters to be used during the sample interval. At the end of the sample interval, the procedure reads the values in the counters, prints a report, and stops executing.

You can direct sp_sysmon to print information for RepAgent counters only or for all Adaptive Server counters. sp_sysmon displays RepAgent counter information for each database.

See the Adaptive Server Enterprise Performance and Tuning Guide for complete usage and syntax information for sp_sysmon.

See Replication Server Administration Guide Volume 2 > Use Counters to Monitor Performance to use counters to monitor Replication Server activity.

• Invoke sp_sysmon
  You can invoke sp_sysmon by using fixed time intervals, or by using the begin_sample and end_sample parameters.
• Sample Output from sp_sysmon of RepAgent Activity
  View a sample output of RepAgent counter activity from sp_sysmon.
• Description of Sample Output of RepAgent Counter Activity
  Each section in the sample output of RepAgent counter activity from sp_sysmon describes a different activity.