Purpose
Overview
RS Monitor Counter Analysis 15.7.1
- 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)
http://www.sybase.com/files/White_Papers/Sybase_RepServer_Performance_Tuning_wp_022708.pdf
Package Contents
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
__________________________________________________________________________________________________________
8 Comments
Former Member
Hi,
I am not able to download the zip file. Is it no longer available?
Thanks,
Amer
Dale Newth
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
Former Member
does this package still exist so that we can download it
Dale Newth
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
Marilyn Airey
The latest version is now:
Dale Newth
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
Dale Newth
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
Dale Newth
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