Article ID: 956240 - View products that this article applies to.
The Microsoft SQL Server process may consume lots of CPU resources on the server that hosts the Microsoft System Center Operations Manager 2007 database. This problem may occur after you make Operations Manager 2007 configuration changes by using the Operations console or by using the Operations Manager 2007 Software Development Kit (SDK) programmatically.
For example, this problem may occur after you make the following Operations Manager 2007 configuration changes:
This problem occurs because some SQL queries that the Data Abstraction Layer (DAL) component of Operations Manager 2007 runs force SQL Server to build a new plan every time that the Configuration service runs an SQL statement.
Update InformationThis fix is contained within the Microsoft System Center Operations Manager 2007 Service Pack 1 update. To see a list of issues are fixed and how to obtain the cumulative rollup, refer to this article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/971541/ )Description of System Center Operations Manager 2007 Service Pack 1
Hotfix informationA supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.
If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the hotfix.
Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site:
PrerequisitesYou must have Microsoft System Center Operations Manager 2007 Service Pack 1 (SP1) installed to apply this hotfix. This hotfix must be applied on each computer that meets the following criteria:
Restart requirementYou do not have to restart the computer after you apply this hotfix.
Hotfix replacement informationThis hotfix does not replace any other hotfixes.
File informationThe English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.
Operations Manager 2007, x64-based version
Collapse this tableExpand this table
Operations Manager 2007, x86-based version
Collapse this tableExpand this table
To extract the management pack files that are contained in this hotfix, follow these steps:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in Microsoft System Center Operations Manager 2007 R2.
This hotfix optimizes the SQL queries to reduce the CPU usage of the SQL Server process when you make Operations Manager 2007 configuration changes.
After you apply this hotfix by using the Run Software Update option in the System Center Operations Manager 2007 Software Update dialog box, you must run a Transact-SQL statement against the Operations Manager operational database in SQL Server. To do this in SQL Server Management Studio, follow these steps:
(http://support.microsoft.com/kb/824684/ )Description of the standard terminology that is used to describe Microsoft software updates
For a list of issues that are fixed in Microsoft System Center Operations Manager 2007 R2, refer to the following article in the Microsoft Knowledge base:
(http://support.microsoft.com/kb/971410/ )List of issues that are fixed in System Center Operations Manager 2007 R2