Non-Critical State

Microsoft.SQLServerAppliance.APS.StorageInternal.DiskStateMonitor.NonCritical (UnitMonitor)

This monitor detects if Disk Component is in Non-Critical state.

Knowledge Base article:

Summary

The disk array is reporting a non-critical status. The array is in an unexpected state, but the system is still operational.

Causes

This can be caused by a disk warning or an issue in the RAID array.

The vendor's hardware agent is reporting this status in the component's disk_rollup_status property. For more details, view the disk_rollup_status property in the PDW Admin Console or query the sys.dm_pdw_component_health_status DMV.

Resolutions

Contact Microsoft Support and provide them with the alert name and details.

To diagnose this issue, Microsoft Support will require Windows administrator access to the affected APS Host node in order to access the vendor’s integrated system user interface.

To resolve this issue, Microsoft Support will contact the vendor’s hardware support team. Depending on the problem, the vendor might require physical access to the appliance.

Element properties:

Target

Microsoft.SQLServerAppliance.APS.StorageInternal.Disk

Parent Monitor

System.Health.AvailabilityState

Category

AvailabilityHealth

Enabled

True

Alert Generate

True

Alert Severity

Warning

Alert Priority

Normal

Alert Auto Resolve

True

Monitor Type

Microsoft.SQLServerAppliance.APS.ComponentTwoStateType

Remotable

True

Accessibility

Public

Alert Message

Disk array has NON-CRITICAL overall status

Appliance Name: {0}
Node Name: {1}
Component: {2}
Component Details: https://{3}/Fabric/Health/NodeDetails/{4}?compId={5}

RunAs

Default

Source Code:

<UnitMonitor ID="Microsoft.SQLServerAppliance.APS.StorageInternal.DiskStateMonitor.NonCritical" Accessibility="Public" Enabled="true" Target="APSLibrary!Microsoft.SQLServerAppliance.APS.StorageInternal.Disk" ParentMonitorID="Health!System.Health.AvailabilityState" TypeID="Microsoft.SQLServerAppliance.APS.ComponentTwoStateType" Remotable="true" Priority="Normal" ConfirmDelivery="false">

  <Category>AvailabilityHealth</Category>

  <AlertSettings AlertMessage="Microsoft.SQLServerAppliance.APS.StorageInternal.DiskStateMonitor.NonCritical.AlertMessage">

    <AlertOnState>Warning</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Warning</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Target/Property[Type="APSLibrary!Microsoft.SQLServerAppliance.APS.Component"]/ApplianceID$</AlertParameter1>

      <AlertParameter2>$Target/Property[Type="APSLibrary!Microsoft.SQLServerAppliance.APS.Component"]/NodeName$</AlertParameter2>

      <AlertParameter3>$Target/Property[Type="System!System.Entity"]/DisplayName$</AlertParameter3>

      <AlertParameter4>$Target/Property[Type="APSLibrary!Microsoft.SQLServerAppliance.APS.Component"]/ApplianceNetworkAddress$</AlertParameter4>

      <AlertParameter5>$Target/Property[Type="APSLibrary!Microsoft.SQLServerAppliance.APS.Component"]/NodeID$</AlertParameter5>

      <AlertParameter6>$Target/Property[Type="APSLibrary!Microsoft.SQLServerAppliance.APS.Component"]/ID$</AlertParameter6>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="Good" MonitorTypeStateID="Good" HealthState="Success"/>

    <OperationalState ID="Bad" MonitorTypeStateID="Bad" HealthState="Warning"/>

  </OperationalStates>

  <Configuration>

    <IntervalSeconds>900</IntervalSeconds>

    <SyncTime/>

    <TimeoutSeconds>600</TimeoutSeconds>

    <ConnectionString>$Target/Property[Type="APSLibrary!Microsoft.SQLServerAppliance.APS.Component"]/ApplianceTdsAddress$</ConnectionString>

    <NodeName>$Target/Property[Type="APSLibrary!Microsoft.SQLServerAppliance.APS.Component"]/NodeName$</NodeName>

    <GroupName>$Target/Property[Type="APSLibrary!Microsoft.SQLServerAppliance.APS.Component"]/GroupName$</GroupName>

    <ComponentName>$Target/Property[Type="System!System.Entity"]/DisplayName$</ComponentName>

    <MonitoredState>NonCritical</MonitoredState>

  </Configuration>

</UnitMonitor>