Documentation/Info - Interval Processor CPU %
TimH
Posts: 1 New member
When looking at SQL Monitor for one of my database servers there is a section titled "SQL User Processes (Top 10 by CPU)". Three is a column titled "Interval Processor CPU %". All 10 of my records have 97%+. Is there any documentation on this section or column?
Answers
But if there was a time slice where an issue was reported it might have or track large operations from a Host that might help you pinpoint something based on host name.
In my environment(s) I rarely find myself ever looking at this.
I opened a support case a couple of weeks ago (after posting here), and the support folks said "After discussing this with the team it appears that in some cases with the way we collect data for the user processes in fact under-represents them and so they may not appear. Correcting this would have a knock on effect to other parts of the application and the team are still deciding the best course of action to take here, but nothing is currently planned. For now, any user processes should also appear in the top 10 processes (if they are in the top 10 based on what column is being used to sort the table- e.g. top 10 by CPU or logical reads) and so you should use that table in the meantime"
In other words, this feature is not really working correctly currently.