TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

SQL Server, Database Replica

 

Applies To: SQL Server 2016

The SQLServer:Database Replica performance object contains performance counters that report information about the secondary databases of an Always On availability group in SQL Server 2016. This object is valid only on an instance of SQL Server that hosts a secondary replica.

Counter NameDescriptionView on…
File Bytes Received/secAmount of FILESTREAM data received by the secondary replica for the secondary database in the last second.Secondary replica
Log Bytes Received/secAmount of log records received by the secondary replica for the database in the last second.Secondary replica
Log remaining for undoThe amount of log in kilobytes remaining to complete the undo phase.Secondary replica
Log Send QueueAmount of log records in the log files of the primary database, in kilobytes, that has not yet been sent to the secondary replica. This value is sent to the secondary replica from the primary replica. Queue size does not include FILESTREAM files that are sent to a secondary.Secondary replica
Mirrored Write Transaction/secNumber of transactions that were written to the primary database and then waited to commit until the log was sent to the secondary database, in the last second.Primary replica
Recovery QueueAmount of log records in the log files of the secondary replica that has not yet been redone.Secondary replica
Redo blocked/secNumber of times the redo thread is blocked on locks held by readers of the database.Secondary replica
Redo Bytes RemainingThe amount of log in kilobytes remaining to be redone to finish the reverting phase.Secondary replica
Redone Bytes/secAmount of log records redone on the secondary database in the last second.Secondary replica
Total Log requiring undoTotal kilobytes of log that must be undone.Secondary replica
Transaction DelayDelay in waiting for unterminated commit acknowledgement, in milliseconds.Primary replica

Monitor Resource Usage (System Monitor)
SQL Server, Availability Replica
SQL Server, Databases Object
AlwaysOn Availability Groups (SQL Server)

Community Additions

ADD
Show:
© 2016 Microsoft