locked
Noise RRS feed

  • Question

  • Hello,

    We have a windows 2003 cluster with two nodes on which 2 SSAS (SQL Server Analysis Services 2005) instances are installed.

    If one SSAS instance is downed several alerts are generated. Is it possible to generate only one alert ?

    For example:

    Cluster name : CL01

    Node 1 : node1

    Node 2 :node2

    Instance SSAS 1 : SSAS1\OLAP

    Instance SSAS 2 : SSAS2\OLAP2

    If OLAP instance hosting by node 1 is down we receive 3 alerts like below.

    CL01\OLAP down

    Node1\OLAP down

    SSAS1\OLAP2 down ! (very strange)

    Thanks


    Eric

    Wednesday, June 13, 2012 3:34 PM

Answers

  • You're right with your assumption

    There are multiple relations being formed:

    SQL instance hosts OLAP-cube

    Cluster Node hosts OLAP-cube (as a cluster resource)

    Cluster hosts OLAP-cube (as a cluster resource)

    When the OLAP-cube becomes unavailable, all 3 relationships will generate an alert. There is no correlation between the cluster-resource object and the OLAP-cube, so Operations Manager doesn't know their relationship.

    Disable the alerts (scope the overrides to only the OLAP-objects) and keep only the alert(s) that best describe the problem.

    • Marked as answer by Yog Li Thursday, June 28, 2012 7:59 AM
    Thursday, June 14, 2012 10:30 AM

All replies

  • You are probably getting alerts from the SQL management pack and the clustering management pack.

    You'll have to choose what alerts make the most sense to you, and disable the other ones. This could be done by grouping the affected items in an instancegroup and creating overrides on this group for the monitors/rules you want to disable. Assess firmly that the overrides are properly scoped, so that you keep receiving alerts for unrelated events.

    Wednesday, June 13, 2012 5:39 PM
  • I've just schek group

    This group is populated with objects belonging to "SQL Role"

    In this one each SSAS instance name appears serveral time.

    For example OLAP instance is associated with cluster name, node, instance name.

    Perhaps it's the reason why I receive many alert when my OLAP instance is down.

    Any idea to restrict alerts ?

    Thanks


    Eric

    Thursday, June 14, 2012 9:42 AM
  • You're right with your assumption

    There are multiple relations being formed:

    SQL instance hosts OLAP-cube

    Cluster Node hosts OLAP-cube (as a cluster resource)

    Cluster hosts OLAP-cube (as a cluster resource)

    When the OLAP-cube becomes unavailable, all 3 relationships will generate an alert. There is no correlation between the cluster-resource object and the OLAP-cube, so Operations Manager doesn't know their relationship.

    Disable the alerts (scope the overrides to only the OLAP-objects) and keep only the alert(s) that best describe the problem.

    • Marked as answer by Yog Li Thursday, June 28, 2012 7:59 AM
    Thursday, June 14, 2012 10:30 AM