What are the challenges you face when working across database platforms? Take the survey

No objects returned from WMI Class Win32_PerfRawData_PerfOS_Processor in SQL Monitor


I am trying to put SQL Monitor to localhost of a machine but I am getting this error message. Do you know the reason ?


  • Options
    Eddie DEddie D Posts: 1,789 Rose Gold 5
    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:
    cd c:\windows\system32
    lodctr /R
    cd c:\windows\sysWOW64
    lodctr /R
    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Options
    MertuzanMertuzan Posts: 3 New member

    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.
  • Options
    EricRitzieEricRitzie Posts: 1 New member
    Was this ever resolved? I am having the same issue on Windows Server 2016 Standard.
  • Options
    MertuzanMertuzan Posts: 3 New member
    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.
Sign In or Register to comment.