Using $system.discover_performance_count ers


Hi all,

need your help. I'm executing the following query on my SSAS instance and it returns all the performance counter except for those from Processor category. Why the query doesn't return \Processor(_Total)\% Processor Time? Am I missing something?

select  *
from systemrestrictschema ( $system.discover_performance_counters, 
PERF_COUNTER_NAME = '\Processor(_Total)\% User Time', 
PERF_COUNTER_NAME = '\Processor(_Total)\% Processor Time',
PERF_COUNTER_NAME = '\Processor(_Total)\% Privileged Time',
PERF_COUNTER_NAME = '\Memory\Available Bytes', 
PERF_COUNTER_NAME = '\Memory\Cache Bytes', 
PERF_COUNTER_NAME = '\Memory\Standby Cache Normal Priority Bytes',
PERF_COUNTER_NAME = '\Memory\Page Faults/sec', 
PERF_COUNTER_NAME = '\System\Processes', 
PERF_COUNTER_NAME = '\System\Threads', 
PERF_COUNTER_NAME = '\System\System Up Time'
)

Thanks for your help

December 4th, 2014 7:12am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics