This monitor type checks the amount of free space of the database on MSSQL Database against the specified thresholds. The monitor type can check for absolute free space, or free space expressed as percentage.
RunAs | Default |
Accessibility | Internal |
Support Monitor Recalculate | False |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | Microsoft.SQLServer.Windows.DataSource.DBSize | Default |
CDOverThreshold1UnderThreshold2 | ConditionDetection | System.ExpressionFilter | Default |
CDOverThreshold2 | ConditionDetection | System.ExpressionFilter | Default |
CDUnderThreshold1 | ConditionDetection | System.ExpressionFilter | Default |
HC | ConditionDetection | Microsoft.SQLServer.Windows.ConditionDetection.MultiValueSpaceHealthCalculator | Default |
ID | ParameterType | Selector | Display Name | Description |
---|---|---|---|---|
IntervalSeconds | int | $Config/IntervalSeconds$ | Interval (seconds) | The recurring interval of time in seconds in which to run the workflow. |
SyncTime | string | $Config/SyncTime$ | Synchronization Time | The synchronization time specified by using a 24-hour format. May be omitted. |
HealthCalcMode | int | $Config/HealthCalcMode$ | Health Calculation Mode | Defines how to track the health state. The following values are possible: "1" - prioritizes the health state based on the Threshold parameter expressed as a percentage term (\%), "2" - prioritizes the health state based on the Threshold parameter expressed as a capacity metric (MB), "3" - prioritizes the health state based on both the percentage term (\%) and the capacity metric (MB) thresholds, and uses the worst one to report the state. |
Threshold1 | double | $Config/Threshold1$ | Critical Threshold (\%) | The monitor changes its state to 'Critical' if the value drops below this threshold. The monitor reports the 'Warning' state if the health state is between this threshold and 'Warning Threshold (\%)'. |
Threshold2 | double | $Config/Threshold2$ | Warning Threshold (\%) | The monitor changes its state to 'Warning' if the value drops below this threshold. |
Threshold21 | double | $Config/Threshold21$ | Critical Threshold (MB) | The monitor changes its state to 'Critical' if the value drops below this threshold. The monitor reports the 'Warning' state if the health state is between this threshold and 'Warning Threshold (MB)'. |
Threshold22 | double | $Config/Threshold22$ | Warning Threshold (MB) | The monitor changes its state to 'Warning' if the value drops below this threshold. |
TimeoutSeconds | int | $Config/TimeoutSeconds$ | Timeout (seconds) | Specifies the time the workflow is allowed to run before being closed and marked as failed. |
AzureMaxFileSizeMB | int | $Config/AzureMaxFileSizeMB$ | Azure Maximum File Size (MB) | The maximum size of data file stored in Azure BLOB Storage. The workflow will consider this value as a maximum storage capacity for each file. |
<UnitMonitorType ID="Microsoft.SQLServer.Windows.MonitorType.Database.DBSize" Accessibility="Internal">
<MonitorTypeStates>
<MonitorTypeState ID="UnderThreshold1"/>
<MonitorTypeState ID="OverThreshold1UnderThreshold2"/>
<MonitorTypeState ID="OverThreshold2"/>
</MonitorTypeStates>
<Configuration>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="MachineName" type="xsd:string"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="NetbiosComputerName" type="xsd:string"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="InstanceName" type="xsd:string"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="DatabaseName" type="xsd:string"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="AzureMaxFileSizeMB" type="xsd:int"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="HealthCalcMode" type="xsd:int"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="ValuePropertyName" type="xsd:string"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Value2PropertyName" type="xsd:string"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Threshold1" type="xsd:double"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Threshold2" type="xsd:double"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Threshold21" type="xsd:double"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Threshold22" type="xsd:double"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="ConnectionString" type="xsd:string"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="InstanceVersion" type="xsd:string"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="InstanceEdition" type="xsd:string"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="MonitoringType" type="xsd:string"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="SqlTimeoutSeconds" type="xsd:integer"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="TimeoutSeconds" type="xsd:integer"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="IntervalSeconds" type="xsd:integer"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="SyncTime" type="xsd:string"/>
</Configuration>
<OverrideableParameters>
<OverrideableParameter ID="IntervalSeconds" ParameterType="int" Selector="$Config/IntervalSeconds$"/>
<OverrideableParameter ID="SyncTime" ParameterType="string" Selector="$Config/SyncTime$"/>
<OverrideableParameter ID="HealthCalcMode" ParameterType="int" Selector="$Config/HealthCalcMode$"/>
<OverrideableParameter ID="Threshold1" ParameterType="double" Selector="$Config/Threshold1$"/>
<OverrideableParameter ID="Threshold2" ParameterType="double" Selector="$Config/Threshold2$"/>
<OverrideableParameter ID="Threshold21" ParameterType="double" Selector="$Config/Threshold21$"/>
<OverrideableParameter ID="Threshold22" ParameterType="double" Selector="$Config/Threshold22$"/>
<OverrideableParameter ID="TimeoutSeconds" ParameterType="int" Selector="$Config/TimeoutSeconds$"/>
<OverrideableParameter ID="AzureMaxFileSizeMB" ParameterType="int" Selector="$Config/AzureMaxFileSizeMB$"/>
</OverrideableParameters>
<MonitorImplementation>
<MemberModules>
<DataSource ID="DS" TypeID="Microsoft.SQLServer.Windows.DataSource.DBSize">
<MachineName>$Config/MachineName$</MachineName>
<NetbiosComputerName>$Config/NetbiosComputerName$</NetbiosComputerName>
<InstanceName>$Config/InstanceName$</InstanceName>
<DatabaseName>$Config/DatabaseName$</DatabaseName>
<AzureMaxFileSizeMB>$Config/AzureMaxFileSizeMB$</AzureMaxFileSizeMB>
<ConnectionString>$Config/ConnectionString$</ConnectionString>
<InstanceVersion>$Config/InstanceVersion$</InstanceVersion>
<InstanceEdition>$Config/InstanceEdition$</InstanceEdition>
<MonitoringType>$Config/MonitoringType$</MonitoringType>
<SqlTimeoutSeconds>$Config/SqlTimeoutSeconds$</SqlTimeoutSeconds>
<TimeoutSeconds>$Config/TimeoutSeconds$</TimeoutSeconds>
<IntervalSeconds>$Config/IntervalSeconds$</IntervalSeconds>
<SyncTime>$Config/SyncTime$</SyncTime>
</DataSource>
<ConditionDetection ID="HC" TypeID="Microsoft.SQLServer.Windows.ConditionDetection.MultiValueSpaceHealthCalculator">
<HealthCalcMode>$Config/HealthCalcMode$</HealthCalcMode>
<StateType>ThreeState</StateType>
<Value1Name>$Config/ValuePropertyName$</Value1Name>
<Value1StateDirection>BadLessT1</Value1StateDirection>
<Threshold11>$Config/Threshold1$</Threshold11>
<Threshold12>$Config/Threshold2$</Threshold12>
<Value2Name>$Config/Value2PropertyName$</Value2Name>
<Value2StateDirection>BadLessT1</Value2StateDirection>
<Threshold21>$Config/Threshold21$</Threshold21>
<Threshold22>$Config/Threshold22$</Threshold22>
<Publisher>SQLMonitoringWindows</Publisher>
<ManagementGroupName>$Target/ManagementGroup/Name$</ManagementGroupName>
</ConditionDetection>
<ConditionDetection ID="CDUnderThreshold1" TypeID="System!System.ExpressionFilter">
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="Integer">Property[@Name='__workflowState']</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value Type="Integer">2</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
</ConditionDetection>
<ConditionDetection ID="CDOverThreshold1UnderThreshold2" TypeID="System!System.ExpressionFilter">
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="Integer">Property[@Name='__workflowState']</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value Type="Integer">1</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
</ConditionDetection>
<ConditionDetection ID="CDOverThreshold2" TypeID="System!System.ExpressionFilter">
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="Integer">Property[@Name='__workflowState']</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value Type="Integer">0</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
</ConditionDetection>
</MemberModules>
<RegularDetections>
<RegularDetection MonitorTypeStateID="UnderThreshold1">
<Node ID="CDUnderThreshold1">
<Node ID="HC">
<Node ID="DS"/>
</Node>
</Node>
</RegularDetection>
<RegularDetection MonitorTypeStateID="OverThreshold1UnderThreshold2">
<Node ID="CDOverThreshold1UnderThreshold2">
<Node ID="HC">
<Node ID="DS"/>
</Node>
</Node>
</RegularDetection>
<RegularDetection MonitorTypeStateID="OverThreshold2">
<Node ID="CDOverThreshold2">
<Node ID="HC">
<Node ID="DS"/>
</Node>
</Node>
</RegularDetection>
</RegularDetections>
</MonitorImplementation>
</UnitMonitorType>