rs_statdetail table

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

Description

Stores counter metrics that have been flushed to the RSSD.

Column

Datatype

Description

run_id

rs_id

Number assigned to the run or observation period.

instance_id

int

An ID that identifies a module instance.

Counters are grouped by modules. A module may have one instance or multiple instances. Defined module IDs are used when available. For example, the instance_id for a DSI module is the database ID asssociated with the DSI.

instance_val

int

An ID that identifies a module instance when instance_id cannot identify it uniquely.

counter_id

int

Unique counter identification number.

counter_val

int

Value of counter for the current run or observation period.

label

varchar(255)

Descriptive information about the module instance associated with the counter, such as the data server and database name.

Indexes

Unique, nonclustered key rs_key_statdetail on (run_id, instance_id, instance_val, counter_id)