MSSQL 2017 on Windows: Average length of the row chains in the hash buckets Probe Action

Microsoft.SQLServer.2017.Windows.ProbeAction.HashIndexAvgChainLength (ProbeActionModuleType)

Average length of the row chains in the hash buckets Action on Windows

Element properties:

Show References:
- DataSource Modules (1)

Type	ProbeActionModuleType
Isolation	Any
Accessibility	Internal
RunAs	Default
InputType	System.BaseData
OutputType	System.PropertyBagData

Source Code:

<ProbeActionModuleType ID="Microsoft.SQLServer.2017.Windows.ProbeAction.HashIndexAvgChainLength" Accessibility="Internal" Batching="false">

  <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="InstanceName" type="xsd:string"/>

    <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="MonitoringType" type="xsd:string"/>

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

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Password" 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="Publisher" type="xsd:string"/>

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

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

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

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

  </Configuration>

  <ModuleImplementation>

    <Managed>

      <Assembly>Microsoft.SQLServer.2017.Windows.Module.Monitoring.Assembly</Assembly>

      <Type>Microsoft.SQLServer2017.Windows.Module.Monitoring.Monitors.HashIndexAvgChainLength</Type>

    </Managed>

  </ModuleImplementation>

  <OutputType>System!System.PropertyBagData</OutputType>

  <InputType>System!System.BaseData</InputType>

</ProbeActionModuleType>