The MOMHost process stops responding when multiple SQL scripts are run in the same process on a computer that has the Microsoft Operations Manager Agent installed (885738)

SYMPTOMS

When you run a script that is included with the Microsoft Operations Manager (MOM) 2005 SQL Management Pack on a MOM Management computer or on a computer that has the MOM 2005 Agent installed, an error may occur in the MOMHost process. When this problem occurs, the following event may be logged in the application event log on the MOM Management computer or on the computer that has the MOM Agent installed:

Event Type: Warning
Event Source: Microsoft Operations Manager
Event Category: MOM Agent
Event ID: 21245
Date: 7/15/2004
Time: 5:16:10 PM
User: NT AUTHORITY\NETWORK SERVICE
Computer: ComputerName
Description:
The response processor failed to execute a response. The response returned the error message:
The remote procedure call failed.

Response Details:
Rule ID: {C7F86A50-B4FC-42E0-BA3E-848898DEF700}
Response description: script: Hang

For more information, see Help and Support Center at http://support.microsoft.com.

CAUSE

This problem occurs if any one of the following conditions is true:

Multiple instances of the same SQL Management Pack script are running in the same process, and the SQL Management Pack script requires access to SQL Server Distributed Management Objects (SQLDMO).
Two or more SQL Management Pack scripts are running in the same process, and both scripts require access SQL Server Distributed Management Objects.

In this case, the SQLDMO are static and the SQL Management Pack scripts cannot use locks to access these objects. Therefore, if two SQL Management pack scripts that access SQLDMO try to access the same object, the MOMHost process may stop responding. This problem also occurs if multiple instances of the same script that access SQLDMO try to access the same object.

MORE INFORMATION

The MOMHost process is designed to host multiple scripts that are running at the same time while they are isolated from the MOM Service. If multiple scripts that are running in the same process try to access the same object, and the object is not thread-safe, the MOMHost process may stop responding. This is also true if multiple instances of the same script are running in the same process. However, the MOM 2005 agent is not destabilized, and the MOMHost process will recover automatically and will resume typical operation.