Databases Reference
In-Depth Information
COUNTER
DESCRIPTION
Batches >=010000ms & <020000ms
Number of SQL Batches with a response time
greater than or equal to 10,000ms but less
than 20,000ms
Batches >=020000ms & <050000ms
Number of SQL Batches with a response time
greater than or equal to 20,000ms but less
than 50,000ms
Batches >=050000ms & <100000ms
Number of SQL Batches with a response time
greater than or equal to 50,000ms but less
than 100,000ms
Batches >=100000ms
Number of SQL Batches with a response time
greater than or equal to 100,000ms
Database
Replica
File Bytes Received/sec
Amount of fi lestream data received by the
availability replica for the database
Log Bytes Received/sec
Amount of logs received by the availability
replica for the database
Log remaining for undo
The amount of log in kilobytes remaining to
fi nish the undo phase
Log Send Queue
Amount of logs in kilobytes waiting to be sent
to the database replica
Mirrored Write Transactions/sec
Number of transactions that wrote to the mir-
rored database in the last second, that waited
for log to be sent to the mirror
Recovery Queue
Total number of hardened log in kilobytes that
is waiting to be redone on the secondary
Redo blocked/sec
Number of times redo gets blocked in the last
second
Redo Bytes Remaining
The amount of log in kilobytes remaining to be
redone to fi nish the reverting phase
Redone Bytes/sec
Amount of log records redone in the last sec-
ond to catch up the database replica
Total Log requiring undo
The amount of log in kilobytes that need to be
undone
Transaction Delay
Number of milliseconds transaction termina-
tion waited for acknowledgement per second
continues
Search WWH ::
Custom Search