| title | sp_replcounters (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/03/2017 | ||
| ms.prod | sql-server-2016 | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | fe585b1f-edda-421f-81d6-8a03a3a535d2 | ||
| caps.latest.revision | 24 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
Returns replication statistics about latency, throughput, and transaction count for each published database. This stored procedure is executed at the Publisher on any database.
Transact-SQL Syntax Conventions
sp_replcounters
| 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. |
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)