To save statistics in the RSSD, include the save option. Otherwise, Replication Server sends results to the computer screen.
When you send statistics to the RSSD, you can specify the number of observations (num_obs) during the specified time period. That is, you can tell Replication Server to read the named counters multiple times during the sampling period. Multiple observations allow you to see how counter data changes over the duration of the sample period.
For example, to collect statistics for all counters for 60 seconds, with four observation intervals, enter:
admin stats, "all", save, 4, 60
To collect statistics for the outbound SQT for connection 108 for two minutes, enter:
admin stats, sqt, outbound, 108, save, 4, 120
Replication Server determines the observation interval by dividing the sample period by the number of observations and adding any remainder to the final interval. For example, if the sample period is 120 seconds and the number of observations is seven, Replication Server assumes six observation intervals of 17 seconds each and a final observation interval of 18 seconds. The number of observations must be at least one, and each observation interval must be at least 15 seconds—except when the number of observations is one.
Sampling period (sample_period) |
Number of observations (num_obs) |
Number of observation intervals |
|---|---|---|
60 seconds |
4 |
Four 15-second intervals |
75 seconds |
20 |
Not allowed – observation interval must be => 15 seconds |
60 seconds |
2 |
Two 30-second intervals |
60 seconds |
1 |
One 60-second interval |
120 seconds |
7 |
Six 17-second intervals and a final 18-second interval |
10 seconds |
1 |
One 10-second interval |
When you execute admin stats with a nonzero time period using the save option, Replication Server:
Truncates the rs_statrun and rs_statdetail system tables.
Resets all counters.
Turns on all counters.
Puts your session to sleep for the specified sample period.
Writes the requested counters to the RSSD at the end of each observation period.
Turns off all counters.
Make sure that you have dumped any needed information
from rs_statrun and rs_statdetail before
executing admin stats with the save option. See “Using the rs_dump_stats procedure” for information
about dumping information from these tables.
