I need to do some monitoring on a SQL server that's eating up CPU. But perfmon is missing the "thread" and "process" objects. Is there a way to add them in here?
Specifically, I need to see thread/%_processor_time to identify which threads in the SQL instance are causing the problem, so I can figure out which queries are going awry.
Specifically, I need to see thread/%_processor_time to identify which threads in the SQL instance are causing the problem, so I can figure out which queries are going awry.
