Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 904737 - Last Review: January 30, 2007 - Revision: 1.2
A memory leak may occur in the MOMhost process when you run some SQL Management Pack scripts in MOM 2005
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:
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.
Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
in the "Applies to" section.
For more information, click the following article
numbers to view the articles in the Microsoft Knowledge Base:
885738Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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 Â
(http://kbalertz.com/Feedback.aspx?kbNumber=899556/
)
You may experience performance issues when you use SQL Server Distributed Management Objects (SQL-DMO) components in a multithreaded environment
APPLIES TO
- Microsoft Operations Manager (MOM) 2005
| kbperformance kbtshoot kbprb KB904737 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate