Home
  •  

Instance Free Storage Space Left

Microsoft.Azure.ManagedInstance.Monitor.DBEngine.FreeStorageSpace (UnitMonitor)

Monitors the space on the media hosting the Instance data in percentage terms.

Knowledge Base article:

Summary

This monitor checks the space on the media hosting the Azure SQL Managed Instance data in percentage terms.

Causes

An unhealthy state is caused by having low free space instance storage size.

Resolutions

For more information on technical characteristics and resource limits for Azure SQL Managed Instance, see: Service tier characteristics

Overridable Parameters

Name

Description

Default Value

Alert Priority

Defines Alert Priority.

High

Alert Severity

Defines Alert Severity.

Match monitor’s health

Critical Threshold

The monitor will change its state to Critical if the value drops below this threshold. Being between this threshold and the warning threshold (inclusive) will result in the monitor being in a warning state.

10

Enabled

Enables or disables the workflow.

Yes

Generates Alerts

Defines whether the workflow generates an Alert.

Yes

Interval (seconds)

The recurring interval of time in seconds in which to run the workflow.

900

Synchronization Time

The synchronization time specified by using a 24-hour format. May be omitted.

 

Timeout (seconds)

Specifies the time the workflow is allowed to run before being closed and marked as failed.

300

Warning Threshold

The monitor will change its state to Warning if the value drops below this threshold.

20

Element properties:

TargetMicrosoft.Azure.ManagedInstance.DBEngine
Parent MonitorSystem.Health.PerformanceState
CategoryPerformanceHealth
EnabledTrue
Alert GenerateTrue
Alert SeverityMatchMonitorHealth
Alert PriorityHigh
Alert Auto ResolveTrue
Monitor TypeMicrosoft.Azure.ManagedInstance.MonitorType.DBEngine.FreeStorageSpace
RemotableTrue
AccessibilityPublic
Alert Message
Azure SQL MI: Instance Free Storage Space is low

Managed Instance "{0}" is running out of free storage space. See "Alert Context" tab for more details.

Space available: {1}MB ({2}\%).
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.Azure.ManagedInstance.Monitor.DBEngine.FreeStorageSpace" Accessibility="Public" Enabled="true" Target="MngdInstD!Microsoft.Azure.ManagedInstance.DBEngine" ParentMonitorID="Health!System.Health.PerformanceState" Remotable="true" Priority="Normal" TypeID="Microsoft.Azure.ManagedInstance.MonitorType.DBEngine.FreeStorageSpace" ConfirmDelivery="false">

  <Category>PerformanceHealth</Category>

  <AlertSettings AlertMessage="Microsoft.Azure.ManagedInstance.Monitor.DBEngine.FreeStorageSpace.AlertMessage">

    <AlertOnState>Warning</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>High</AlertPriority>

    <AlertSeverity>MatchMonitorHealth</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Target/Property[Type="MngdInstD!Microsoft.Azure.ManagedInstance.DBEngine"]/InstanceName$</AlertParameter1>

      <AlertParameter2>$Data/Context/Property[@Name='FreeStorageSpaceMB']$</AlertParameter2>

      <AlertParameter3>$Data/Context/Property[@Name='FreeStorageSpacePercent']$</AlertParameter3>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="UnderThreshold1" MonitorTypeStateID="UnderThreshold1" HealthState="Error"/>

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

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

  </OperationalStates>

  <Configuration>

    <InstanceName>$Target/Property[Type="MngdInstD!Microsoft.Azure.ManagedInstance.DBEngine"]/InstanceName$</InstanceName>

    <Tier>$Target/Property[Type="MngdInstD!Microsoft.Azure.ManagedInstance.DBEngine"]/Tier$</Tier>

    <HardwareGeneration>$Target/Property[Type="MngdInstD!Microsoft.Azure.ManagedInstance.DBEngine"]/HardwareGeneration$</HardwareGeneration>

    <ReadScaleOutReplicaType>$Target/Property[Type="MngdInstD!Microsoft.Azure.ManagedInstance.DBEngine"]/ReadScaleOutReplicaType$</ReadScaleOutReplicaType>

    <Threshold1>10</Threshold1>

    <Threshold2>20</Threshold2>

    <ConnectionString>$Target/Property[Type="MngdInstD!Microsoft.Azure.ManagedInstance.DBEngine"]/ConnectionString$</ConnectionString>

    <AuthType>$Target/Property[Type="MngdInstD!Microsoft.Azure.ManagedInstance.DBEngine"]/AuthType$</AuthType>

    <AuthorityDetails>$Target/Property[Type="MngdInstD!Microsoft.Azure.ManagedInstance.DBEngine"]/AuthorityDetails$</AuthorityDetails>

    <SqlTimeoutSeconds>15</SqlTimeoutSeconds>

    <TimeoutSeconds>300</TimeoutSeconds>

    <IntervalSeconds>900</IntervalSeconds>

    <SyncTime/>

  </Configuration>

</UnitMonitor>