Today I have received the following alert from SCOM:
Alert: Workflow Runtime: Failed to run a WMI query
Alert description: Object enumeration failed
Query: ‘SELECT StartMode, State FROM Win32_Service WHERE Name = ‘MSSQLSERVER”
Details: The paging file is too small for this operation to complete.
One or more workflows were affected by this.
This alert was raised by Windows Server 2008 R2-based computer and I believe that it is caused by an error explained in KB981314: The “Win32_Service” WMI class leaks memory in Windows Server 2008 R2 and in Windows 7 – http://support.microsoft.com/kb/981314.
This hotfix contains updated Cimwin32.dll which is located in %SYSTEMROOT%\System32\wbem folder. Updated file version is 6.1.7600.20683.
NOTE: Installation of KB981314 requires computer restart.