Skip to end of metadata
Go to start of metadata

Purpose

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.

Overview

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

RS Monitor Counter Analysis 15.7.1

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:

  1.  Async Parser (PRSNRM) support hasn’t been tested and may not report accurately
  2. 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
  3. 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
  4. 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)

If you hit any issues (including confusion/question about any of the warnings), please send the counters and syntax of command executed to jeff.tallman@sap.com.

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:

http://www.sybase.com/files/White_Papers/Sybase_RepServer_Performance_Tuning_wp_022708.pdf

Please note that the paper is very dated (primarily 15.0 version) and may not contain all the counters nor describe features added after RS 15.0 to which the counters reflect.

Package Contents

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.

Contents:

The package consists of the following files:

        

  

Directory

  
  

Filename

  
  

Comments

  

.

RS_MonitorCounters.xlsx

MS Excel 2010   Spreadsheet containing the list of all the RS Monitor Counter descriptions   (each RS version on separate tab)

.\model

RS_MonitorCounters_157.pdm

PowerDesigner 16.1 model   of the tables and procs used for analysis – essentially a subset of the RS   15.7+ RSSD

.\collect

bcp_out_rssd.bat

Sample script to bcp out   the statistics as well as relevant other system tables from the RSSD of the   monitored server

.\collect

rs_stats_cancel.rcl

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.

.\collect

rs_stats_collect_15x.rcl

The file containing the   RCL to turn on statistics sampling.    Only editing necessary is the length of time to collect statistics   for.

.\collect

trace_dsi_workload.rcl

A script to turn off the   DSI_WORKLOAD trace flag used to ensure AOBJ counters are collected in 15.6

.\collect

trace_rs_ticket.rcl

A script to turn on (or   off) the tracing of rs_tickets to the RS errorlog

.\collect

truncate_stats.sql

A file containing the   truncate commands to clear the statistics after a collection.  Needs to be invoked with isql   –D<RSSD_db_name>.

.\load

bcp_in_rssd.bat

Script to load the RS MC   statistics and other RSSD tables

.\load

fix_names.bat

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.

.\load

gunzip_data.bat

Script to gunzip data   collected and zipped with gzip (.tgz or .tar.gz)

.\load

sample_run.sql

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.

.\load

truncate_tables.sql

Script to truncate the   analysis schema before loading new statistics

.\load

unix2dos_data.bat

Script to convert data   from unix to dos format (<CR/LF>)

.\load

update_statistics.sql

Script to update index   statistics after statistics are uploaded

.\setup\unix_utils

gzip_tar.zip

Zip archive containing   GNU gzip and tar utilities for MS Windows

.\setup\unix_utils

unix2dos.zip

Zip archive containing   unix2dos utility for MS Windows

.\setup

bcp_in_rs_datatype

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).

.\setup

drop_all_tables.sql

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.

.\setup

readme.txt

A quick   file explaining how to create the RS MC analysis database….for those who   didn't feel the need to read this doc.

.\setup

rep_analysis_157_db.sql

Script to create the   analysis database

.\setup

rep_mc_tables_157.sql

Script to create the   partial RSSD schema used by the analysis stored procedures

.\setup

rs_mc_analysis_procs_157.sql

Script containing the   analysis stored procedures

.\setup

rs_report_headings.sql

Script containing the   report headings for the analysis report procedures

.\setup

rs_report_explanations.sql

Script containing the   explanations for each section of the report

.\setup

truncate_log.sql

A code fragment used to   build rs_mc_analysis_procs_157.sql, but also useful for truncating the log   when necessary or desired.

Related Content

Here is the link to  entire .zip file with the complete Monitors and counters package:

RS_157_r1_3.zip

 

__________________________________________________________________________________________________________

  • No labels

8 Comments

  1. Former Member

    Hi,

    I am not able to download the zip file. Is it no longer available?

     

    Thanks,

    Amer

  2. Hi Amer,

     

    The latest version of the monitors and counters is RS_157_r1_3.zip located here:

     

    https://mdocs.sap.com/mcm/public/v1/open?shr=yzkqvINwKu5gyWXHhPb0J06XyNrskZOPIY52FQEpyqA&obj=Wera3mXs4yfG8gKlkmMV2JfGO7w2rZB2gWrAKQ64_I4

     

     

    Regards,

     

    Dale Newth

    Digital Business Services

    1-800-677-7271

    dale.newth@sap.com

  3. Former Member

    does this package still exist so that we can download it

  4. Hi Ivan,

     

    The previous note's link should now work again to download the version 1.3

    https://mdocs.sap.com/mcm/public/v1/open?shr=yzkqvINwKu5gyWXHhPb0J06XyNrskZOPIY52FQEpyqA&obj=Wera3mXs4yfG8gKlkmMV2JfGO7w2rZB2gWrAKQ64_I4

     

    Thanks!!!

     

    Dale Newth

    Digital Business Services

    1-800-677-7271

    dale.newth@sap.com

     

    P.S. Have you heard about Expert Chat?
    Please check out the following links and find out on how to start benefiting from our
    Brand New Support Channel:
    https://blogs.sap.com/2016/06/14/get-faster-answers-to-your-support-questions-with-chat/
    https://launchpad.support.sap.com/#/notes/2213344/E

  5. The latest version is now:

  6. Hello,

     

    The latest version of the monitors and counters is located here:

    https://mdocs.sap.com/mcm/public/v1/open?shr=FYmN_tYVVjO49cjbNWwhO-5JQ1s9ZUYgUod8OpMi4e4

     

    Dale Newth

    Digital Business Services

    1-800-677-7271

    dale.newth@sap.com

  7. The Latest version is now out at this share:

    https://sap-my.sharepoint.com/:f:/p/dale_newth/EhWXGozfP7lGmGiqoRpUUZUBE9v4B4UGl0o3p1Nq3bopXA

     

    Dale Newth

    Digital Business Services

    1-800-677-7271

    dale.newth@sap.com

  8. Hello,

     

    The latest version of the monitors and counters is located here:

    https://mdocs.sap.com/mcm/public/v1/open?shr=FYmN_tYVVjO49cjbNWwhO-5JQ1s9ZUYgUod8OpMi4e4

     

    Dale Newth

    Digital Business Services

    1-800-677-7271

    dale.newth@sap.com