Generate Performance Reports

Use the rs_stat_populate and rs_stat_genreport stored procedures to generate performance reports.

You must 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 rs_stat_populate and rs_stat_genreport to generate these performance reports:

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 and rs_stat_genreport, see the script file, which contains syntax, examples, and other information.