IDERA SQL Inventory Manager uses the Windows Management Instrumentation (WMI) interface to collect information about the servers that make up your environment.

Under certain circumstances, IDERA SQL Inventory Manager is unable to access the WMI counters. When the WMI counters are unavailable, IDERA SQL Inventory Manager cannot display performance information from the servers.

When IDERA SQL Inventory Manager is unable to collect WMI information, it generates an alert. The alert includes an error message that indicates the underlying problem.

IDERA SQL Inventory Manager may be unable to retrieve the WMI information for one or more of the following reasons:

  • The WMI counters are disabled.
  • The performance library is overloaded.
  • The WMI repository is corrupt.

If IDERA SQL Inventory Manager is unable to retrieve the WMI information from one or more servers, you should locate and correct the issue that prevents IDERA SQL Inventory Manager from collecting the WMI information.

When you troubleshoot WMI availability, there are several procedures that IDERA recommends to correct the issue. You should perform the following checks in the specified order. If you encounter an error when you perform any of these procedures, please contact IDERA Technical Support for additional assistance.

  • Verify that the WMI system is available.
  • Verify that the performance counter class is accessible.
  • Verify that the performance counter instance is accessible.
  • Verify that the Windows performance counters are enabled on the server.
  • Change the WMI counter timeout.
  • Resynchronize the WMI Performance Library.
  • Update the WMI Registry and register the WMI DLL files.
  • Salvage the WMI Repository.
  • Rebuild the list of WMI counters.
  • Assign additional memory to the WMI pool.

 

IDERA SQL Inventory Manager lets you discover and visualize your SQL Server environment. Learn more > >
  • No labels