SQLServer Replication-Subscriber Object

The following counters are part of the SQLServer Replication-Subscriber object. They provide information about the delivery of transactions from the distribution database to the destination database.

Delivered Transactions

The number of delivered transactions in the distribution database. A delivered transaction is one that has already been executed against the destination database, but still resides in the distribution database.

Delivered Transactions/sec

The number of transactions delivered per second¾that is, the number of jobs per second that were executed in the last batch sent to the subscription server from the distribution server.

Delivered Latency (sec)

The number of seconds a transaction remains in the distribution database before delivery to the subscription server¾that is, the time between a job being inserted in the distribution database and being executed against the destination database.

Undelivered Transactions

The number of undelivered transactions in the distribution database. An undelivered transaction is one that has not been executed against the destination database.