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. rs_stat_populate reads data from rs_statdetail, summarizes, augments, denormalizes, and saves result into rs_statreport, where rs_stat_genreport reads data and generates report.
Load this script into the RSSD after upgrading to Replication Server 15.1:
$SYBASE/$SYBASE_REP/scripts/rs_install_statreport_v1510_[ase|asa].sql
After loading the script, run the stored procedures rs_stat_populate and rs_stat_genreport. Running these stored procedures produces this information:
Replication Server performance overview – overview information about your Replication Servers, such as DIST processing, DSI processing, and so on.
Replication Server performance analysis – performance analysis and tuning suggestions based on critical Replication Server counters. The detailed description is available in the script file.
Active object identification result – lists the active table and procedure names, owner names, execution times, and so on.
For more information about rs_stat_populate, rs_stat_genreport, rs_statreport, and rs_statdetail, see the script file, which contains syntax, examples, and so on.