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 "Ikona łącza do tematu")
Transact-SQL Syntax Conventions
Składnia
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. |
Uwagi
sp_replcounters is used in transactional replication.
Permissions
Requires membership in the db_owner fixed database role or sysadmin fixed server role.