Consumer parameters
The following parameters are grouped as Consumer parameters:
- ARATest
- AvgLatchWaitTime
- BLockerProcs
- BufferCacheHitRatio
- BytesRecievedFromReplica
- BytesSentToReplica
- BytesSentToTransport
- CacheHitRatio
- ConnectionsAvailable
- ConnectionsRemaining
- ConnectionState
- CPUBusy
- CPUIdle
- CPUIOBusy
- DatabaseLockAvgWaitTime
- DatabaseLockRequestsPerSec
- DatabaseLockRequestsWaitPercent
- DatabaseSpaceUsedMB
- DatabaseStatus
- DatabaseSpaceUsedPct
- DeadlocksPerSec
- DeliveredCmdsPerSec
- DeliveredTransPerSec
- DeliveryLatency
- DiskIOErrors
- DiskIOReads
- DiskIOWrites
- DistributorLatency
- ErrorLogDiskFreeSpace
- ErrorLogDiskSpaceFreeThreshold
- ErrorLogSizeMB
- ErrorLogSizeThreshold
- ErrorLogUpdates
- ExtentLockAvgWaitTime
- ExtentLockRequestsPerSec
- ExtentLockRequestWaitPercent
- Failover
- FailoverMode
- FileSizeMB
- FileBytesRecieved
- FlowControl
- FlowControlTIme
- FullScansPerSec
- IdleProcs
- IsSuspended
- KeyLockRequestPerSec
- KeyLockRequestWaitPercent
- LogBytesRecieved
- LazyWritesPerSec
- ListenerState
- LockRequestsPerSec
- LockRequestWaitPercent
- LocksRemaining
- LogBackupStatus
- LogRestorationStatus
- LogRemainingForUndo
- LogSendQueue
- LogSpaceUsedMB
- LogSpaceUsedPct
- LongRunningTrans
- MemoryGrantsPending
- MemoryPageRead
- MemoryPageWrites
- MirrorRole
- MirrorState
- MirroredWriteTransaction
- NumberOfFreeBuffers
- NumBlockedProcesses
- NumCurrentLocks
- NumCurrentUsers
- NumProcesses
- ObjectDataSizeMB
- ObjectReservedSizeMB
- OldestUnsentTransaction
- OpertationalState
- OutstandingReads
- OutstandingWrites
- PacketErrors
- PacketsRecieved
- PacketsSent
- PageLifeExpentency
- PageLockAvgWaitTime
- PageLockRequestWaitPercent
- PageSplits
- PCProcBuffersActivePct
- PCProcBuffersUsedPct
- PCProcCacheActivePct
- PCProcCacheUsedPct
- RecoveryHealth (Always-On Availability Group Replica)
- RecoveryHealth (Always-On Availability Group)
- RecievesFromReplica
- RecoveryQueue
- RedoBlocked
- RedoneBytes
- RedoBytesRemaining
- RedoBytesPerSec
- RedoQueueKB
- ReplicatedTransPerSec
- ReplicatedCommandsPerSec
- ResentMessages
- ResponseExecTime
- ResponseSqlTime
- RIDLockAvgWaitTime
- RIDLockRequestWaitPercent
- Role (Always-On Availability Group)
- Role (Always-On Availability Group Replica)
- RowCountEstimate
- SendRate
- SendsToReplica
- SendsToTransport
- SpaceUsedMB (file)
- SpaceUsedMB (filegroup)
- SpaceUsedPCT (file)
- SpaceUsedPCT (filegroup)
- SQLServerStatus
- SubscriberLatency
- SuspendReason
- SynchronizationHealth (Always-On Availability Group)
- SynchronizationHealth (Always-On Availability Group Replica)
- SynchronizationHealth (Always-On Availability Group Database)
- TableLockAvgWaitTime
- TableLockRequestsPerSec
- TableLockRequestWaitPercent
- TimeToRestore
- TimeToSend
- TotalServerMemory
- TotalLogRequiringUndo
- TransactionDelay (Always-On Availability Group)
- TransactionDelay (Database Mirroring)
- TransactionsPerSec (Database Mirroring)
- TransactionsPerSec (Performance)
- UnsentLog
- UserBlocked
- UserConnections
- UserCpu
- UserDefCounter1-10
- UserIdle
- UserIo
- UserMemUsage
- UserTotCpu
- UserTotIo
- WitnessServerStatus
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*