No objects returned from WMI Class Win32_PerfRawData_PerfOS_Processor in SQL Monitor

Answers

• Eddie D Redgate › Posts: 1,802 Rose Gold 5

  August 25, 2020 10:45AM

  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 Davis
  Senior Product Support Engineer
  Redgate Software Ltd
  Email: support@red-gate.com

  0 · Share on Twitter
• Mertuzan Posts: 3 Bronze 1

  August 25, 2020 10:52AM

  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.

  0 · Share on Twitter
• EricRitzie Posts: 1 New member

  September 4, 2020 6:23PM

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

  0 · Share on Twitter
• Mertuzan Posts: 3 Bronze 1

  September 8, 2020 8:57AM

  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.

  0 · Share on Twitter