MSSQL 2016: DB Disk Write Latency monitor type

Microsoft.SQLServer.2016.Database.DiskWriteLatency.MonitorType (UnitMonitorType)

DB Disk Write Latency monitor type for 2016 DBs

Element properties:

Member Modules:

Overrideable Parameters:

Source Code:

<UnitMonitorType ID="Microsoft.SQLServer.2016.Database.DiskWriteLatency.MonitorType" Accessibility="Internal" RunAs="GPMP!Microsoft.SQLServer.MonitoringAccount">

  <MonitorTypeStates>

    <MonitorTypeState ID="Normal"/>

    <MonitorTypeState ID="Error"/>

  </MonitorTypeStates>

  <Configuration>

    <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="TimeoutSeconds" type="xsd:integer"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Threshold" type="xsd:double"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="NumSamples" type="xsd:integer"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="SyncTime" type="xsd:string"/>

  </Configuration>

  <OverrideableParameters>

    <OverrideableParameter ID="IntervalSeconds" Selector="$Config/IntervalSeconds$" ParameterType="int"/>

    <OverrideableParameter ID="TimeoutSeconds" Selector="$Config/TimeoutSeconds$" ParameterType="int"/>

    <OverrideableParameter ID="Threshold" Selector="$Config/Threshold$" ParameterType="double"/>

    <OverrideableParameter ID="NumSamples" Selector="$Config/NumSamples$" ParameterType="int"/>

    <OverrideableParameter ID="SyncTime" Selector="$Config/SyncTime$" ParameterType="string"/>

  </OverrideableParameters>

  <MonitorImplementation>

    <MemberModules>

      <DataSource ID="DS" TypeID="Microsoft.SQLServer.2016.DBEngine.DiskLatency.DataSource">

        <IntervalSeconds>$Config/IntervalSeconds$</IntervalSeconds>

        <TimeoutSeconds>$Config/TimeoutSeconds$</TimeoutSeconds>

        <SyncTime>$Config/SyncTime$</SyncTime>

        <ComputerName>$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

        <SqlInstanceName>$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$</SqlInstanceName>

      </DataSource>

      <ConditionDetection ID="DBExsist" TypeID="System!System.ExpressionFilter">

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery Type="String">Property[@Name='Name']</XPathQuery>

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value Type="String">$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </ConditionDetection>

      <ConditionDetection ID="Mapper" TypeID="SystemPerf!System.Performance.DataGenericMapper">

        <ObjectName>$Data/Property[@Name='MaxWriteMountPoint']$</ObjectName>

        <CounterName>DB Avg. Disk ms/Read</CounterName>

        <InstanceName>$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$</InstanceName>

        <Value>$Data/Property[@Name='MaxWrite']$</Value>

      </ConditionDetection>

      <ConditionDetection ID="CSC" TypeID="SystemPerf!System.Performance.ConsecutiveSamplesCondition">

        <Threshold>$Config/Threshold$</Threshold>

        <Direction>greater</Direction>

      </ConditionDetection>

      <ConditionDetection ID="NormalCondition" TypeID="System!System.ExpressionFilter">

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery Type="Double">Value</XPathQuery>

            </ValueExpression>

            <Operator>Less</Operator>

            <ValueExpression>

              <Value Type="Double">$Config/NumSamples$</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </ConditionDetection>

      <ConditionDetection ID="ErrorCondition" TypeID="System!System.ExpressionFilter">

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery Type="Double">Value</XPathQuery>

            </ValueExpression>

            <Operator>GreaterEqual</Operator>

            <ValueExpression>

              <Value Type="Double">$Config/NumSamples$</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </ConditionDetection>

    </MemberModules>

    <RegularDetections>

      <RegularDetection MonitorTypeStateID="Normal">

        <Node ID="NormalCondition">

          <Node ID="CSC">

            <Node ID="Mapper">

              <Node ID="DBExsist">

                <Node ID="DS"/>

              </Node>

            </Node>

          </Node>

        </Node>

      </RegularDetection>

      <RegularDetection MonitorTypeStateID="Error">

        <Node ID="ErrorCondition">

          <Node ID="CSC">

            <Node ID="Mapper">

              <Node ID="DBExsist">

                <Node ID="DS"/>

              </Node>

            </Node>

          </Node>

        </Node>

      </RegularDetection>

    </RegularDetections>

  </MonitorImplementation>

</UnitMonitorType>