none
Failover Cluster Validation Report with warnings

    问题

  • Hi,

    I have 2 Node cluster on windows 2008 R2 with SQL Server 2008 R2 Cluster. i have run cluster validation report and found following warnings pls suggest and guide me health of cluster and how to fix and remove these warnigns. thx.

    The "Cluster Group" does not contain a File Share Witness or a Witness disk.
    This is a required resource for the group. It may be difficult to manage the cluster with this resource missing.

    Adapters Local Area Connection 6 and Local Area Connection 5 on node 1 have IP addresses on the same subnet.
    Adapters Local Area Connection and Local Area Connection 4 on node 1 have IP addresses on the same subnet.
    Multiple adapters on node 1 have addresses on the same subnet.

    Node 1 has an IPv4 address XXX.XXX.XXX.XXX configured as Automatic Private IP Address (APIPA) for adapter Local Area Connection 6.
    This adapter will not be added to the Windows Failover Cluster. If the adapter is to be used by Windows Failover Cluster,
    the IPv4 properties of the adapter should be changed to allow assignment of a valid IP address that is not in the APIPA range.
    APIPA uses the range of 169.254.0.1 thru 169.245.255.254 with subnet mask of 255.255.0.0.

    The HostRecordTTL property for network name 'Name: ClusterNAME' is set to 1200 ( 20 minutes).
    For multi-site clusters the suggested value is 300 (5 minutes).

    The HostRecordTTL property for network name 'Name: ClusterDTC' is set to 1200 ( 20 minutes).
    For multi-site clusters the suggested value is 300 (5 minutes).

    The HostRecordTTL property for network name 'Name: ClusterSSQL' is set to 1200 ( 20 minutes).  For multi-site clusters the suggested value is 300 (5 minutes).

    Node 1 is reachable from Node 2 by only one pair of interfaces. It is possible that this network path is a single point of failure for communication within the cluster. Please verify that this single path is highly available or consider adding additional networks to the cluster.


    Node 2 is reachable from Node 1 by only one pair of interfaces. It is possible that this network path is a single point of failure for communication within the cluster. Please verify that this single path is highly available or consider adding additional networks to the cluster.

    Analysis Services

    This resource is configured to run in a separate monitor. By default, resources are configured to run in a shared monitor.
    This setting can be changed manually to keep it from affecting or being affected by other resources.  It can also be set automatically by the failover cluster. If a resource fails it will be restarted in a  separate monitor to try to reduce the impact on other resources if it fails again.
    This value can be changed by opening the resource properties and selecting the 'Advanced Policies' tab.  There is a check-box 'run this resource in a separate Resource Monitor'.

    This resource is configured to run in a separate monitor. By default,  resources are configured to run in a shared monitor.
    This setting can be changed manually to keep it from affecting or being affected by other resources.  It can also be set automatically by the failover cluster.  If a resource fails it will be restarted in a separate monitor to try to reduce the impact on other resources if it fails again.
    This value can be changed by opening the resource properties and selecting the 'Advanced Policies' tab.  There is a check-box 'run this resource in a separate Resource Monitor'.

    The servers do not all have the same software updates. Hotfix Id KB2525694 on Node 1


    iffi

    2012年3月13日 4:52

答案

  • On the same node typically there would only be one NIC (unless they are teamed) on the same subnet. Recommend you re-evaluate your network strategy/design for this cluster. Typically there would be two (or more) network interfaces on their own subnet. At least one for Public / SQL Server Application traffic and the other for Private / cluster heartbeat traffic.

    "Node x is reachable from Node y by only one pair of interfaces" seems to indicate you don't have 2 separate networks as indicated above.

    "The servers do not all have the same software updates. Hotfix Id KB2525694 on Node 1" - ensure all nodes have the same service packs and hotfixes.

    2012年3月15日 5:53