0

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.

  • There is a Connect item about this - are you going across domains? – Aaron Bertrand Jul 29 '16 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 '16 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 '16 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 '16 at 21:01
-1

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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