Replication Published Database Overview (PI_RPDB)
- Organization of this page
Function
The Replication Published Database Overview (PI_RPDB) record indicates replication information related to database distribution transactions. One record is created for each database published in transaction replication.
This is a multi-instance record.
Default and changeable values
Item |
Default value |
Changeable |
---|---|---|
Collection Interval |
60 |
Y |
Collection Offset |
0 |
Y |
Log |
No |
Y |
LOGIF |
(Blank) |
Y |
Over 10 Sec Collection Time |
No |
N |
ODBC key field
PI_RPDB_DB_NAME
Lifetime
From the time a publisher database is created until the time it is deleted
Record size
-
Fixed part: 681 bytes
-
Variable part: 313 bytes
Fields
View name (Manager name) |
Description |
Summary |
Format |
Delta |
Data source |
---|---|---|---|---|---|
DB Name (DB_NAME) |
Database name#1 |
COPY |
string(257) |
No |
sp_replcounters.Database |
Record Time (RECORD_TIME) |
Interval end time (GMT format)#1 |
COPY |
time_t |
No |
Agent Collector |
Record Type (INPUT_RECORD_TYPE) |
Record type (always RPDB)#1 |
COPY |
char(8) |
No |
Agent Collector |
Replicated Trans (REPLICATED_TRANSACTIONS) |
Number of transactions inside the log that are waiting to be distributed to the distribution database#2 |
AVG |
ulong |
No |
sp_replcounters.replicated transactions |
Replicated Trans/sec (REPLICATED_TRANSACTIONS_PER_SEC) |
Number of transactions per second distributed to the distribution database#2 |
AVG |
double |
No |
sp_replcounters.replication rate trans/sec |
Replication Latency (REPLICATION_LATENCY) |
The average latency (in seconds) from when a transaction is registered into a log to when the transaction is distributed#2 |
AVG |
double |
No |
sp_replcounters.replication latency (sec) |
Start Time (START_TIME) |
Interval start time (GMT format)#1 |
COPY |
time_t |
No |
Agent Collector |