CPU usage % (CPUUsagePercentage)
The CPU bandwidth usage by all requests in all workload groups belonging to this pool. This is measured relative to the computer and normalized to all CPUs on the system. This value will change as the amount of CPU available to the SQL Server process changes. It is not normalized to what the SQL Server process receives.
BMC PATROL properties
Property | Default value |
|---|---|
Application class | MSSQL_SERVER_PERFMON_RESOURCE_POOL_STATS |
Command type | NA |
Platform | All |
Icon style | Graph |
Unit | Percent |
Border range | Undefined |
Alarm1 range | Undefined |
Alarm2 range | Undefined |
Scheduling (poll time) | Inherited |
Active at installation | No |
Parameter type | Consumer |
TrueSight/ BMC Helix Operations Management properties
Property | Default value |
|---|---|
Monitor type | MS SQL Server Perfmon Resource Pool Stats |
Key Performance Indicator | No |
Monitor for abnormalities | No |
Graph by default | No |
Availability | No |
Response time | No |
Normal distribution | No |
Statistical | No |