This page is to introduce your to the SAP Replication Server's monitors and counters, and to provide you with a process that will allow you to interpret this information to increase the performance of your SAP Replication Server.
Please download the .zip from the link at the bottom of the page and go to the document: 'RS Monitor Counter Analysis 15_7_1 r1.0.doc' to get detailed instructions on how to install and use the reports included to begin to performance tune your SAP Replication Server
This package supports RS 15.2, 15.5, 15.6, 15.7 and 15.7.1 thru 15.7.1 sp100, although due to some counters not being present in releases prior to 15.7, some of the counter values will be all zeros. Known issues include:
- Async Parser (PRSNRM) support hasn’t been tested and may not report accurately
- Multi-Path Replication (MPR) support has been added and tested for MDSI – but not sure how to handle dedicated routes/multiple rep agents other than as single connections
- Support has been added for rs_help*, rs_dump_stats RSSD procs normally installed in RS RSSD. There may be issues with pre-15.7 RS’s as proc functionality is from RS 15.7.1 based on the 15.7.1 RSSD schema – as a result, some aspects (e.g. repdef versioning) may cause issues with earlier releases such as 15.2
- RS 15.2 support requires using rs_databases_152 (or rs_databases_152_upg), rs_objects_152 and rs_columns_152 as bcp targets. At this stage, you will need to manually determine when to use rs_databases_152 (RS 15.2 install) vs. rs_databases_152_upg (pre 15.2 upgraded to 15.2 – column ordering difference is issue)
This package of stored procedures is used to help analyze Sybase Replication Server performance via the RS Monitor Counters – a set of statistical counters that measure the number of times a particular code path is executed in the Replication Server. For tips about which counters are more critical – or what they might indicate – please download the Replication Server Performance & Tuning Guide white paper (v2.0.1 as of this writing). This white paper is available at the link:
The package contains a number of Unix utilities for windows as well as SQL scripts. The intent for the package is remote collection and analysis using an external database. Both ASE RSSD’s and ASA embedded eRSSD’s are supported for the monitored Replication Servers, however, only ASE 15.5+ is supported for the analysis database. ASE 15.7 is strongly recommended for the analysis database – note that a 4KB page size or higher database is required. The rationale is due to the fact that most of the logic in the stored procedures performs table pivoting of rs_statdetail and in many cases the resulting row-width exceeds the limit of a 2KB page.
MS Excel 2010 Spreadsheet containing the list of all the RS Monitor Counter descriptions (each RS version on separate tab)
PowerDesigner 16.1 model of the tables and procs used for analysis – essentially a subset of the RS 15.7+ RSSD
Sample script to bcp out the statistics as well as relevant other system tables from the RSSD of the monitored server
Cancels any currently running statistics collection. Note that it does not truncate the statistics tables in the RSSD. This script is useful for sites that wish to run the collection repeatedly using cron or other scheduler and find that previous collections may bleed into next collection.
The file containing the RCL to turn on statistics sampling. Only editing necessary is the length of time to collect statistics for.
A script to turn off the DSI_WORKLOAD trace flag used to ensure AOBJ counters are collected in 15.6
A script to turn on (or off) the tracing of rs_tickets to the RS errorlog
A file containing the truncate commands to clear the statistics after a collection. Needs to be invoked with isql –D<RSSD_db_name>.
Script to load the RS MC statistics and other RSSD tables
A script created for people who can't follow directions - attempts to rename the statistics files bcp'd out into the specific names that the bcp in scripts expect.
Script to gunzip data collected and zipped with gzip (.tgz or .tar.gz)
A script that shows several sample execution syntaxes for both the summary and the detail report procedures. For the detail report, examples demonstrating using routes are included.
Script to truncate the analysis schema before loading new statistics
Script to convert data from unix to dos format (<CR/LF>)
Script to update index statistics after statistics are uploaded
Zip archive containing GNU gzip and tar utilities for MS Windows
Zip archive containing unix2dos utility for MS Windows
Script to load rs_datatype and rs_tvalues tables. These tables are optional for analysis, but do support the reverse engineering procedures in case you wish to see the repdef/subscription definitions without connecting back to the production RS(s).
A script that drops all procedures and tables from the analysis database – useful for when patching with later versions as it removes the entire analysis schema.
A quick file explaining how to create the RS MC analysis database….for those who didn't feel the need to read this doc.
Script to create the analysis database
Script to create the partial RSSD schema used by the analysis stored procedures
Script containing the analysis stored procedures
Script containing the report headings for the analysis report procedures
Script containing the explanations for each section of the report
A code fragment used to build rs_mc_analysis_procs_157.sql, but also useful for truncating the log when necessary or desired.