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


The information in this article applies to:

  • Microsoft Operations Manager 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 "Troubleshooting" section of the Microsoft SQL Server 2000 Management Pack Guide. To see this information, visit the following Microsoft Web site:

https://www.microsoft.com/technet/prodtechnol/mom/mom2005/maintain/sqlservermpguide_5.mspx#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 "Applies to" 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

Modification Type:MajorLast Reviewed:7/27/2005
Keywords:kbPerformance kbtshoot kbprb KB904737 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.