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
-
Fixed part: 709 bytes
-
Variable part: 0 bytes
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 |