MS SQL Server Perfmon Resource Pool Stats (MSSQL_SERVER_PERFMON_RESOURCE_POOL_STATS)
The MSSQL_SERVER_PERFMON_RESOURCE_POOL_STATS application class contains performance counters that report information about Resource Governor resource pool statistics. Each active resource pool creates an instance of the MSSQL_SERVER_PERFMON_RESOURCE_POOL_STATS that has the same instance name as the Resource Governor resource pool name.
Application class attributes
Item | Description |
|---|---|
Active | Yes |
Created by | Discovery |
Parent class |
|
Child class | None |
Attributes (parameters)
- Active memory grant amount (KB) (ActiveMemoryGrantAmountKB)
- Active memory grants count (ActiveMemoryGrantsCount)
- Avg Disk Read IO (ms) (AvgDiskReadIO_MS)
- Avg Disk Write IO (ms) (AvgDiskWriteIO_MS)
- Cache memory target (KB) (CacheMemoryTargetKB)
- Compile memory target (KB) (CompileMemoryTargetKB)
- CPU control effect % (CPUControlEffectPercentage)
- CPU delayed % (CPUDelayedPercentage)
- CPU effective % (CPUEffectivePercentage)
- CPU usage % (CPUUsagePercentage)
- CPU usage target % (CPUUsageTargetPercentage)
- CPU violated % (CPUViolatedPercentage)
- Disk Read Bytes/sec (DiskReadBytesSec)
- Disk Read IO/sec (DiskReadIOSec)
- Disk Read IO Throttled/sec (DiskReadIOThrottledSec)
- Disk Write Bytes/sec (DiskWriteBytesSec)
- Disk Write IO/sec (DiskWriteIOSec)
- Disk Write IO Throttled/sec (DiskWriteIOThrottledSec)
- Max memory (KB) (MaxMemoryKB)
- Memory grants/sec (MemoryGrantsSec)
- Memory grant timeouts/sec (MemoryGrantTimeoutsSec)
- Pending memory grants count (PendingMemoryGrantsCount)
- Query exec memory target (KB) (QueryExecMemoryTargetKB)
- Target memory (KB) (TargetMemoryKB)
- Used memory (KB) (UsedMemoryKB)
Was this page helpful? Yes No
Submitting...
Thank you
Comments
Log in or register to comment.