OpsMgr, SCE And MOM Blog

Posts in this blog are provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified in the Terms of Use

KB938991 - The SQL Server 2000 database engine health is not monitored in System Center Operations Manager 2007

KB938991 - The SQL Server 2000 database engine health is not monitored in System Center Operations Manager 2007

  • Comments 1
  • Likes

KB938991 is available via the following link http://support.microsoft.com/kb/938991

 

 

SYMPTOMS

In Microsoft System Center Operations Manager 2007, you view the Microsoft SQL Server state view for a computer that has SQL Server 2000 installed. The SQL Server 2000 database engine health is not monitored.

 

CAUSE

By default, the SQL DB Engine Service Health Rollup monitor is not enabled.
Note This aggregate monitor includes the SQL Service State terminated unexpected monitor and the SQL Service terminated unexpectedly monitor.

 

WORKAROUND

To work around this issue, follow these steps:

1.
In the System Center Operations Manager 2007 Operator Console, click Authoring in the navigation pane.

2.
Under Management Pack objects, click Monitors.

3.
Press CTRL+M to display the Scope Management Pack Objects by target(s) dialog box.

4.
In the Look for search box, type SQL 2000 DB Engine, and then click Find now.

5.
Click to select the SQL 2000 DB Engine check box, and then click OK to display the SQL 2000 DB Engine target.

6.
Expand SQL 2000 DB Engine, expand Entity Health, expand Availability, and then click SQL DB Engine Service Health Rollup.
This aggregate monitor displays No in the Enabled by default column.

7.
To enable this aggregate monitor, right-click SQL DB Engine Service Health Rollup, point to Overrides, point to Override the monitor, and then click For all objects of type: SQL 2000 DB Engine.

8.
In the list of overrides, click to select the Override check box for the Enabled parameter.

9.
Click True in the Override Setting box, and then click OK.

 

MORE INFORMATION

Microsoft regularly releases software updates and service packs. Visit this article in the future to determine whether the issue that is described in this article has been fixed in an update or in a service pack.

Comments
Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment