No objects returned from WMI Class Win32_PerfRawData_PerfOS_Processor in SQL Monitor

• 
  Hi, sorry to hear you're running into an issue!
  
  This problem may be due to a corrupted performance counter or wmi repository.
  Can you please first try the following on the problem server:
  
  1.  From an elevated command prompt - run winmgmt /verifyrepository. Then stop the WMI service by running net stop winmgmt /y​. Once you receive confirmation that the service has stopped, run  winmgmt /resetrepository and then try adding the server again.
  
  2. Should that not help, please try rebuilding your WMI perf counters:
  Open a command line with Elevated rights and then run the following commands:
  

  c:
  cd c:\windows\system32 
  lodctr /R 
  cd c:\windows\sysWOW64 
  lodctr /R
  WINMGMT.EXE /RESYNCPERF
  

  Stop and restart the Performance Logs and Alerts service.
  Stop and restart the Windows Management Instrumentation service.
  Then try adding the server once more.
  
  I hope that helps but please let me know if not.
  
  Many Thanks
  Eddie

  Eddie D August 25, 2020 10:45

  - 0 +
• 
  Hello,
  
  Thanks for coming back to me. We find out that we need to give user Admin access to the server and to performance monitor. That has fixed the issue.

  Mertuzan August 25, 2020 10:52

  - 0 +
• 
  Was this ever resolved? I am having the same issue on Windows Server 2016 Standard.

  EricRitzie September 04, 2020 18:23

  - 0 +
• 
  I elevated the user to have Admin access to Server Machine and SQL Servers Admin in the cluster and this has sorted the issue on that particular cluster.

  Mertuzan September 08, 2020 08:57

  - 0 +

Add comment

Please sign in to leave a comment.