Hitachi

JP1 Version 12 JP1/Performance Management - Agent Option for Microsoft(R) SQL Server


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

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