Return
-
Title
The WMI Class ... is not available in this host error in SQL Server agent log -
Description
Database dashboard CPU Usage is disabled and showing n/a. All other metrics are working fine. The following is seen from the agent log:
ECHO <DB_SQL_Server/5.9.7.20/DB_SQL_Server/DB-SQLServer-hostname-Agent-agent> ERROR [DB-SQLServer-hostname-Agent-wmiThreadPool-1-[DBSS_SQL_Server_Host][YYYY-MM-DD HH:MM:SS.SSS]] com.quest.qsi.fason.core.collection.reader.WMIReader - The WMI Class [Win32_PerfRawData_PerfOS_Processor] is not available in this host. You may need to refresh the Performance Counter Classes by executing the following command in the command prompt: "%windir%\system32\wbem\wmiadap.exe /f"
-
Resolution
- Login to the database server as an administrator
- Open command prompt and execute:
%windir%\system32\wbem\wmiadap.exe /f
- Go to Administration | Agents | Agent Status | Deactivate the database agent having issue | Activate