Unknown State

Microsoft.SQLServerAppliance.PDW.StorageInternal.DiskStateMonitor.Unknown (UnitMonitor)

This monitor detects if Disk Component is in Unknown state.

Knowledge Base article:

Summary

The disk array is reporting an unexpected status. The severity cannot be determined. This alert indicates the array is in an unexpected state, but the system appears to be operational.

Causes

This is 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.

The disk_rollup_status is reported by the vendor’s hardware agent.

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 PDW Management 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.PDW.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.PDW.ComponentTwoStateType

Remotable

True

Accessibility

Public

Alert Message

Disk array has UNKNOWN overall status

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

RunAs

Default

Source Code:

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

  <Category>AvailabilityHealth</Category>

  <AlertSettings AlertMessage="Microsoft.SQLServerAppliance.PDW.StorageInternal.DiskStateMonitor.Unknown.AlertMessage">

    <AlertOnState>Warning</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Warning</AlertSeverity>

    <AlertParameters>

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

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

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

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

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

      <AlertParameter6>$Target/Property[Type="PDWLibrary!Microsoft.SQLServerAppliance.PDW.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="PDWLibrary!Microsoft.SQLServerAppliance.PDW.Component"]/ApplianceID$</ConnectionString>

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

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

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

    <MonitoredState>Unknown</MonitoredState>

  </Configuration>

</UnitMonitor>