The process of monitoring the counters that provide performance information has been improved in Replication Server 15.0.1. Sampling and saving statistics to the RSSD now runs asynchronously, allowing you to execute other Replication Server commands or terminate the session while the sampling continues in the background.
You can check the progress of asynchronous commands to prevent overlaps. When a command is denied due to overlapping, you can cancel the commands in progress to execute another command.
The admin stats command has been modified. The modified command syntax is:
admin { stats | statistics } [, sysmon | "all"
| module_name [, inbound | outbound ] [, display_name] ]
[, server[, database ] | instance_id ]
[, display |, save [, obs_interval ] ]
[, sample_period]
The behavior for the save parameter with a sample_ period has also changed. The admin stats returns the session immediately. Its original num_obs option has been changed to obs_interval, which can be a numeric value in seconds, or a quoted time format string hh:mm[:ss].
To start sampling and saving statistics to the RSSD for one hour and thirty minutes at 20-second intervals, enter:
admin stats, "all", save, 20, "01:30:00"
The new command syntax also supports the cancel option, which stops the currently running command.
admin { stats | statistics } , cancel
For multiple observation intervals (obs_interval),
the data that is saved at the time of cancellation is not deleted.
Replication Server checks the unfinished command to avoid corrupted sampling. If there is any command in progress, running either in the background or in other user sessions, the following commands cannot be executed:
admin stats with any variation of save. For example:
admin stats, "all", save, 30
admin stats with a sampling period. For example:
admin stats, "all", display, 120
Commands that resets counters. For example:
admin stats, reset
When a command is denied, the following error message is returned, and admin stats with the cancel option is required to stop the unfinished command before executing another command.
Admin command failed. Existing command is currently in progress
Commands that display current statistics of your session are allowed to be executed even if there is another command in progress. For example:
admin stats, sqm, inbound, display
The output of the existing admin stats, status command has been modified to include the status of the sampling command:
1> admin stats, status 2> go
Command in progress, sampling period 00:30:00, time elapsed 00:02:32
Sybase Replication Server Statistics Configuration ================================================ Configuration Default Current -------------------- ---------- -------- stats_sampling off on stats_show_zero_counters off off stats_reset_rssd on on
Replication Server 15.0.1 has a new configuration parameter, stats_reset_rssd, which allows you to optionally keep the old sampling data in RSSD by setting its value to off. By default, stats_reset_rssd is turned on.
configure replication server
set stats_reset_rssd to {"on", "off"}
See Chapter 3, “Replication Server Commands” of the Replication Server Reference Manual, for detailed information in using admin stats command.
