3

The % Processor Time graph at Activity Monitor for remote connections stopped working and it grayed out after the physical SQL Server restart (image below), but when I get in the server with the same Domain User it works fine. It was also working fine on remote connections before the restart and I have noticed that it takes significantly more time to load the Processes than before.

% Processor Time grayed out

The problem is happening to all users that try to see the Processor Time remotely including sa and server admins so I would think it´s not a permission issue. The server runs Windows Server 2012 and SQL Server 2012.

What could be happening? or How can I solve this?

Thanks in advance! and sorry about my English.

Improve this question
5
  • There is a Connect item about this - are you going across domains?
    – Aaron Bertrand
    Jul 29, 2016 at 1:56
  • @AaronBertrand I just tried what it says but it didn't work, I even restarted my pc after the changes made to see if it worked but it was useless in my case.
    – Server Demon
    Jul 29, 2016 at 15:04
  • Ok. You know Activity Monitor is neither the best nor the only place to get CPU usage data, right?
    – Aaron Bertrand
    Jul 29, 2016 at 16:09
  • 1
    Yes I know, but I´m the kind of person that can't stand having a problem without an answer, if this happened there is a cause and I do really want to find it, I will keep searching and if I get an answer I will post it here.
    – Server Demon
    Jul 29, 2016 at 21:01
  • The simple solution is to run cd \windows\system32 and then run lodctr /R in order to manually rebuild all performance counters (including the SQL Server performance counters) - this is a known issue (at lest this is one known issue with the same behavior)
    – Ronen Ariely
    Dec 19, 2021 at 3:47

1 Answer 1

Reset to default
0

I know it is not a solution but we had a programmed restart and after that everything works fine, it is a production server so we couldn't restart before but that solved it.

Improve this answer
1
  • For some reason someone downvoted your answer even so it worked for you and therefore can work for the next user (which is common in SO sites and make me hate these systems). I Upvoted the answer even so it is not the solution I would take. The simple solution is to run cd \windows\system32 and then run lodctr /R in order to manually rebuild all performance counters (including the SQL Server performance counters) - this is a known issue (at lest this is one known issue with the same behavior)
    – Ronen Ariely
    Dec 19, 2021 at 3:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.