sp_replcounters (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns replication statistics about latency, throughput, and transaction count for each published database. This stored procedure is executed at the Publisher on any database.

Topic link icon Transact-SQL Syntax Conventions

  
sp_replcounters  
  

Column nameData typeDescription
DatabasesysnameName of the database.
Replicated transactionsintNumber of transactions in the log awaiting delivery to the distribution database.
Replication rate trans/secfloatAverage number of transactions per second delivered to the distribution database.
Replication latencyfloatAverage time, in seconds, that transactions were in the log before being distributed.
Replbeginlsnbinary(10)Log sequence number (LSN) of the current truncation point in the log.
Replendlsnbinary(10)LSN of the next commit record awaiting delivery to the distribution database.

sp_replcounters is used in transactional replication.

Requires membership in the db_owner fixed database role or sysadmin fixed server role.

sp_replcmds (Transact-SQL)
sp_repldone (Transact-SQL)
sp_replflush (Transact-SQL)
System Stored Procedures (Transact-SQL)

Community Additions

ADD
Show: