Critical State

Microsoft.SQLServerAppliance.APS.PowerSupply.PowerSupplyStateMonitor.Critical (UnitMonitor)

This monitor detects if Power Supply is in Critical state.

Knowledge Base article:

Summary

The power supply is in a critical state that can cause the server to enter a degraded state. The power supply is not available and the server will fail if the secondary power supply fails.

Causes

The power supply is not available.

For more details, view the Status reported in the component's ps_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 diagnostic tool to verify the server’s power supply units.

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 to replace a power supply.

Element properties:

Target

Microsoft.SQLServerAppliance.APS.PowerSupply.PowerSupply

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

A power supply has a CRITICAL 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.PowerSupply.PowerSupplyStateMonitor.Critical" Accessibility="Public" Enabled="true" Target="APSLibrary!Microsoft.SQLServerAppliance.APS.PowerSupply.PowerSupply" ParentMonitorID="Health!System.Health.AvailabilityState" TypeID="Microsoft.SQLServerAppliance.APS.ComponentTwoStateType" Remotable="true" Priority="Normal" ConfirmDelivery="false">

  <Category>AvailabilityHealth</Category>

  <AlertSettings AlertMessage="Microsoft.SQLServerAppliance.APS.PowerSupply.PowerSupplyStateMonitor.Critical.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>Critical</MonitoredState>

  </Configuration>

</UnitMonitor>