rs_statcounter table

[CR336244] A description of the rs_statcounter table was not included in Chapter 8, “Replication Server System Tables.”

Description

Stores descriptive information about each counter. These values do not change.

Column

Datatype

Description

counter_id

int

Unique counter identification number

counter_name

varchar(60)

Descriptive counter name

module_name

varchar(30)

Name of module to which the counter belongs

display_name

varchar(30)

Counter name used for RCL commands

counter_type

int

Counter records values of these types:

  • 1 – total

  • 2 – last

  • 3 – maximum

  • 4 – average

counter_status

int

Counter status. Bit-mask values are:

  • 0x001 – intrusive counter (only recorded if intrusive counters are turned on)

  • 0x002 – internal use, does not display

  • 0x004 – sysmon (counter flushed as output of admin statistics, sysmon)

  • 0x008 – must sample (counter sampled at all times)

  • 0x010 – no reset (counter is never reset)

  • 0x020 – duration (typically also intrusive, counter records amount of time to complete an action—usually in .01 seconds)

  • 0x040 – rate (counter measures rate, usually in units per second)

  • 0x080 – keep old (previous value of counter retained, usually to aid calculation during next observation period)

  • 0x100 – configuration (counter records current configuration values)

description

varchar(255)

Description of counter

Indexes

Unique, clustered key rs_key_statcounters on (counter_id)