Database performance statistics
1084
Statistic Scope Description
Idle Checkpoint
Time
Database The total time in seconds spent doing idle
checkpoints.
Idle Checkpoints Database The rate at which checkpoints are
completed by the engine’s idle thread. An
idle checkpoint occurs whenever the idle
thread writes out the last dirty page in the
cache.
Idle Writes Database The rate at which disk writes are issued
by the engine’s idle thread.
Recovery IO
Estimate
Database The estimated number of IO operations
required to recover the database.
Recovery Urgency Database Recovery Urgency is expressed as a
percentage.
Server Idle Waits Server The number of times per second the
server goes idle waiting for IO
completion or a new request.
These statistics describe client/server communications activity.
Statistic Scope Description
Comm:
Buffer Misses
Server The total number of network buffer
allocations exceeding the connection
buffer pool.
Comm:
Bytes Received
Server The rate at which network data (in bytes)
are received.
Comm:
Bytes Sent
Server The rate at which bytes are transmitted
over the network.
Comm:
Free Buffers
Server Number of free network buffers.
Comm:
Multi-packets
Received
Server The rate at which multi-packet deliveries
are received.
Comm:
Multi-packets Sent
Server The rate at which multi-packet deliveries
are transmitted.
Comm:
Packets Corrupted
Server The rate at which corrupt network
packets are being received
Comm:
Packets Dropped
Server The rate at which network packets are
being dropped due to lack of buffer
space.
Comm: Server The rate at which network packets are
Communications
statistics
To Next Page
Loading...