Hitachi

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


Replication Summary Detail (PD_RS)

Organization of this page

Function

The Replication Summary Detail (PD_RS) record indicates a summary of database replication generated by Microsoft SQL Server. Only one record is created.

As indicated in the following table, the fields that can be acquired for this record differ depending on the database type.

Field

Database Type

Publisher

Distrbuter

Subsriber and Otehrs

Articles

Yes

No

No

Delivered Jobs

No

Yes

No

Delivery Latency

No

Yes

No

Delivery Rate

No

Yes

No

Publications

Yes

No

No

Subscriptions

Yes

No

No

None of the above

Yes

Yes

Yes

When a field cannot be acquired, the value is 0.

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

None

Lifetime

From the start until stop of a Microsoft SQL Server instance

Record size

Fields

View name

(Manager name)

Description

Summary

Format

Delta

Data source

Articles

(ARTICLES)

Total number of articles published by the server

--

ulong

No

Each publication database's sysarticle

Delivered Jobs

(DELIVERED_JOBS)

Number of distribution jobs delivered

--

ulong

No

Each distribution database's MSdistribution_history

Delivery Latency

(DELIVERY_LATENCY)

Time between job receipt and delivery (in seconds)

--

ulong

No

Each distribution database's MSdistribution_history

Delivery Rate

(DELIVERY_RATE)

Number of jobs executed per second in the last batch sent to the subscriber

--

double

No

Each distribution database's MSdistribution_history

Publications

(PUBLICATIONS)

Total number of publications for the server

--

ulong

No

Each publication database's syspublications

Record Time

(RECORD_TIME)

Interval end time (GMT format)

--

time_t

No

Agent Collector

Record Type

(INPUT_RECORD_TYPE)

Record type (always RS)

--

char(8)

No

Agent Collector

Start Time

(START_TIME)

Interval start time (GMT format)

--

time_t

No

Agent Collector

Subscriptions

(SUBSCRIPTIONS)

Total number of subscriptions for the server

--

ulong

No

Each publication database's syssubscriptions