Bumped by Community user
    Bumped by Community user
    Bumped by Community user
    Tweeted twitter.com/StackDBAs/status/785326889036550144
2 proper code formatting and version tag
source | link

I utilize the resource governor on my 2016 Sql Server. In prior 2016 sql server versions, this query: select * from master.sys.dm_os_performance_counters opc where opc.object_name = 'SQLServer:Resource Pool Stats' and counter_name = 'CPU usage target %'

select *
from master.sys.dm_os_performance_counters opc
where opc.object_name = 'SQLServer:Resource Pool Stats'
and counter_name = 'CPU usage target %'

Would yield the target value of CPU usage % for the resource pool based on the resource pool configuration settings and system load. However, now they are always zero. I also used perfmon to confirm this (along with running legit queries). Does anyone know why or if this counter changed? According to the msdn article, it should still work.

I utilize the resource governor on my 2016 Sql Server. In prior 2016 sql server versions, this query: select * from master.sys.dm_os_performance_counters opc where opc.object_name = 'SQLServer:Resource Pool Stats' and counter_name = 'CPU usage target %' Would yield the target value of CPU usage % for the resource pool based on the resource pool configuration settings and system load. However, now they are always zero. I also used perfmon to confirm this (along with running legit queries). Does anyone know why or if this counter changed? According to the msdn article, it should still work.

I utilize the resource governor on my 2016 Sql Server. In prior 2016 sql server versions, this query:

select *
from master.sys.dm_os_performance_counters opc
where opc.object_name = 'SQLServer:Resource Pool Stats'
and counter_name = 'CPU usage target %'

Would yield the target value of CPU usage % for the resource pool based on the resource pool configuration settings and system load. However, now they are always zero. I also used perfmon to confirm this (along with running legit queries). Does anyone know why or if this counter changed? According to the msdn article, it should still work.

1
source | link

Sql Server 2016 Counter Reporting Zero

I utilize the resource governor on my 2016 Sql Server. In prior 2016 sql server versions, this query: select * from master.sys.dm_os_performance_counters opc where opc.object_name = 'SQLServer:Resource Pool Stats' and counter_name = 'CPU usage target %' Would yield the target value of CPU usage % for the resource pool based on the resource pool configuration settings and system load. However, now they are always zero. I also used perfmon to confirm this (along with running legit queries). Does anyone know why or if this counter changed? According to the msdn article, it should still work.