Enhanced Monitors and Counters

The enhanced monitors and counters feature allows you to collect the information of the most active tables, procedures and related statistics, and store this information into the Replication Server System Database (RSSD) rs_statdetail table and related tables.

You can use this information to diagnose the replicate database performance issues such as missing indexes on the primary keys, and latency problems in the Replication Agent™ and Stable Queue Transaction interface (SQT)/Distributor (DIST) processing.

• New Active Object Counters
  New counters have been added to count the statement execution time on tables and procedures.
• New Procedure Interface
  To bring out the most active tables and procedures, and related statistics information, Replication Server 15.1 introduces the stored procedures rs_stat_populate and rs_stat_genreport.