[CR336244] A description of the rs_statdetail table was not included in Chapter 8, “Replication Server System Tables.”
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. |
Unique, nonclustered key rs_key_statdetail on (run_id, instance_id, instance_val, counter_id)