sp_replcounters (Transact-SQL)
Returns replication statistics about latency, throughput, and transaction count for each published database. This stored procedure is executed at the Publisher on any database.
Column name | Data type | Description |
|---|---|---|
Database | sysname | Name of the database. |
Replicated transactions | int | Number of transactions in the log awaiting delivery to the distribution database. |
Replication rate trans/sec | float | Average number of transactions per second delivered to the distribution database. |
Replication latency | float | Average time, in seconds, that transactions were in the log before being distributed. |
Replbeginlsn | binary(10) | Log sequence number (LSN) of the current truncation point in the log. |
Replendlsn | binary(10) | LSN of the next commit record awaiting delivery to the distribution database. |
