Udostępnij za pośrednictwem


SQL Server, Database Replica

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

Counter Name

Description

View on…

File Bytes Received/sec

Amount of FILESTREAM data received by the secondary replica for the secondary database in the last second.

Secondary replica

Log Bytes Received/sec

Amount of log records received by the secondary replica for the database in the last second.

Secondary replica

Log remaining for undo

The amount of log in kilobytes remaining to complete the undo phase.

Secondary replica

Log Send Queue

Amount 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/sec

Number 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 Queue

Amount of log records in the log files of the secondary replica that has not yet been redone.

Secondary replica

Redo blocked/sec

Number of times the redo thread is blocked on locks held by readers of the database.

Secondary replica

Redo Bytes Remaining

The amount of log in kilobytes remaining to be redone to finish the reverting phase.

Secondary replica

Redone Bytes/sec

Amount of log records redone on the secondary database in the last second.

Secondary replica

Total Log requiring undo

Total kilobytes of log that must be undone.

Secondary replica

Transaction Delay

Delay in waiting for unterminated commit acknowledgement, in milliseconds.

Primary replica

Zobacz także

Odwołanie

SQL Server, Availability Replica

SQL Server, Databases Object

Inne zasoby

Monitor Resource Usage (System Monitor)

AlwaysOn Availability Groups (SQL Server)