Statistics information for subscriptions includes:
Statistic timestamp – time the statistic was generated.
Start timestamp – time the subscription was last started (resumed).
Number of transactions sucessfully replicated to articles in the subscription.
Number of transactions for articles in the subscription that were skipped because of errors.
Average number of operations in transactions replicated.
Average number of replicate articles involved with each transaction replicated.
Locator value of the last committed transaction for the subscription.
To get statistics information for a specific subscription
Use sp_helpsub with the stats keyword, and specify the subscription:
sp_helpsub stats, sub_name
where sub_name is the name of the subscription.
To get statistics information for all subscriptions
Use sp_helpsub with the stats keyword, without specifying a subscription:
sp_helpsub stats
