Microsoft KB Archive/904737

= A memory leak may occur in the MOMhost process when you run some SQL Management Pack scripts in MOM 2005 =

Article ID: 904737

Article Last Modified on 1/30/2007

-

APPLIES TO


 * Microsoft Operations Manager (MOM) 2005

-





SYMPTOMS
You are trying to monitor a database on a computer that is running Microsoft SQL Server 2000 Management Pack for Microsoft Operations Manager (MOM) 2005. When you run some SQL Management Pack scripts, a memory leak may occur in the MOMhost process (MOMhost.exe).

Additionally, the MOMhost process may restart.

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 Distributed Management Objects (SQL-DMO).
 * Two or more SQL Management Pack scripts are running in the same process, and those scripts are required to use SQL-DMO.

Note This issue is documented in the &quot;Troubleshooting&quot; section of the Microsoft SQL Server 2000 Management Pack Guide. To see this information, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=653d9fb9-b1c6-4702-a152-99852dcb2772&DisplayLang=en#EBAA



CAUSE
This issue occurs because SQL-DMO is not designed to be a multithreaded component. SQL-DMO is not thread safe. Therefore, a memory leak may occur in SQL-DMO when multiple SQL Management Pack scripts are running at the same time.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:

885738 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

899556 You may experience performance issues when you use SQL Server Distributed Management Objects (SQL-DMO) components in a multithreaded environment

Keywords: kbperformance kbtshoot kbprb KB904737

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.