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.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
Syntax
sp_replcounters
Result Sets
| 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. |
Remarks
sp_replcounters is used in transactional replication.
Permissions
Members of the public role can execute sp_replcounters.
See Also
Reference
sp_replcmds (Transact-SQL)
sp_repldone (Transact-SQL)
sp_replflush (Transact-SQL)
System Stored Procedures (Transact-SQL)