You can view information flushed to the rs_statdetail and rs_statrun tables using select and other Transact-SQL commands. If, for example, you want to display flushed information from the dCM module counters, you might enter:
select counter_name, module_name, instance_id, counter_val, run_date from rs_statcounters c, rs_statdetail d, rs_statrun r where c.counter_id = d.counter_id and d.run_id = r.run_id and c.module_name = 'CM' order by counter_name
In this instance, the counters have been configured to flush
every two minutes using the configure replication
server set 'stats_daemon_sleep_time'
to '120' command.
Replication Server displays:
counter_name module_name instance_id counter_val run_date ---------------------- ----------- ----------- ----------- ------------------ CM:Daemon dSTATS schedule count CM 13 1 Feb 26 2001 11:16AM CM:Daemon dSTATS schedule count CM 13 2 Feb 26 2001 11:18AM CM:Daemon dSTATS schedule count CM 13 3 Feb 26 2001 11:20AM CM:Daemon dSTATS schedule count CM 13 4 Feb 26 2001 11:22AM CM:Daemon dSTATS schedule count CM 13 5 Feb 26 2001 11:24AM CM:Daemon dSUB schedule count CM 13 1 Feb 26 2001 11:16AM CM:Daemon dSUB schedule count CM 13 2 Feb 26 2001 11:18AM CM:Daemon dSUB schedule count CM 13 3 Feb 26 2001 11:20AM CM:Daemon dSUB schedule count CM 13 4 Feb 26 2001 11:22AM CM:Daemon dSUB schedule count CM 13 5 Feb 26 2001 11:24AM
