让SCOM2007 R2监控到群集中的 sql server 2005,终于解决了

    技术2022-05-20  32

    当然了,通常情况下的操作步骤

    1 在所有节点上启用代理发现(在控制台实施)

    2 重启所有节点上的服务(在各物理节点上实施)

    To enable the Agent Proxy setting

    Open the Operations console and click the Administration button.

    In the Administrator pane, click Agent Managed.

    Double-click an agent in the list.

    On the Security tab, select Allow this agent to act as a proxy and discover managed objects on other computers.

    Repeat steps 3 through 4 for each agent that is installed on a clustered server.

    After discovery occurs, each physical node of the cluster is displayed in the Operations console in the Agent Managed pane; the cluster and each named application instance are displayed in the Agentless Managed pane.

     

    正常情况下,你可以在代理中看到你的虚拟服务器的名称了,SQL server组里也能看到和监控服务器了。

    但是什么才是SCOM认为的正常的情况下呢?

    正好,我们这有2个群集,一个是sql server 2000, is ok ,一个是sql server 2005 ,就是怎么也发现不到,但是能找到群集的名称

     通过查看 SQL server MP Guid ,找到了原因

    原因呢就是:

    Having a SQL Server cluster resource group that contains more than one network name resource might mean that the clustered SQL Server resource is not monitored. For more information, see Knowledge Base article 919594.

     

    什么意思呢?就是群集名称和SQL server 虚拟服务器的名称都在一个组里的时候,SCOM 只会发现第一个,群集名称是首先创建的,当然只能发现群集名称,那我们的SQL SERVER 2000为什么能发现呢,因为那个群集在创建的时候有2个组,网络名称和SQL虚拟服务器名称分别在不同的组里,所以没有问题。

    怎么解决呢。

    1 创建一个新组,把2个网络名称分开,尝试了下,提示要好多操作,放弃,

    2 http://support.microsoft.com/kb/959865/en-us 给出了另一个方法,就是让SCOM 可以同时发现多个虚拟服务器,即使他们在一个组里 ,R2版本会直接提供此功能 ,如果是2007,需要安装SP1 .

     

    how to do?

    Enabling multiple entries for network name resources

    To enable the functionality that is described in Issue 3 of the Symptoms section, follow these steps:After you apply the update and import the supplied cluster Management Pack library, the cluster resource names will not be discovered automatically. The default functionality may be changed by setting the new Multiple Servers Discovery override setting to True. To do this, follow these steps:

    Install the update as described. Locate the updated Management Pack. The updated Management Pack is named Microsoft.Windows.Cluster.Library.MP.By default, the installation path on a 32-bit version of a Windows operating system is as follows:Program Files/System Center 2007 Hotfix Utility/Q959865By default, the installation path on a 64-bit version of a Windows operating system is as follows:Program Files (x86)/System Center 2007 Hotfix Utility/Q959865 Import the updated Management Pack by using the Management Pack import wizard in the Operations Manager console. After the updated Management Pack is imported, browse to the Authoring space in the Operations Manager console and then select Object Discoveries in the Management Pack Objects node. Click Scope to display the Scope Objects dialog box. In the Look for: field type Virtual Server. Then, select the check box that is next to Virtual Server in the Target column. In the Look for: field, type Windows Cluster Service. Then, select the check box that is next to Windows Cluster Service in the Target column, and then click OK. In the Object Discoveries view, select Windows Clustering Discovery, and then select the override that you want under Action to Override the Object Discovery. From the Override Properties dialog box, select an existing Management Pack or create a new Management Pack to store the override. Check the override check box for Multiple Servers Discovery in the Override-controlled properties list, and then change the Override setting to True. Click OK to store the new override.Note After you do this, multiple network names for cluster resource groups that match the override criteria will be discovered.

    按照上面的操作,SQLSERVER 的虚拟服务器就可以被找到和监控了,因为我也是第一次用SCOM,为这问题,花了点时间,所以写下来 ,希望能帮到和我一样的菜鸟 。

    问题总算解决了


    最新回复(0)