Show High-Fragmented Tables

Microsoft.SQLServerAppliance.MDW.ErrorFragmentedIndexesDiagnostic (Diagnostic)

This Task shows all high-fragmented tables with clustered indexes.

Element properties:

Member Modules:

Source Code:

<Diagnostic ID="Microsoft.SQLServerAppliance.MDW.ErrorFragmentedIndexesDiagnostic" Accessibility="Internal" Enabled="true" Target="SQL2008Disco!Microsoft.SQLServer.2008.Database" Monitor="Microsoft.SQLServerAppliance.MDW.IndexFragmentation" ExecuteOnState="Error" Remotable="true">

  <Category>Operations</Category>

  <ProbeAction ID="PA" TypeID="Microsoft.SQLServerAppliance.MDW.FragmentedIndexesDiagnosticProbe">

    <ConnectionString>$Target/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ConnectionString$</ConnectionString>

    <DataBaseName>$Target/Property[Type="SQL!Microsoft.SQLServer.Database"]/DatabaseName$</DataBaseName>

    <TablesCount>$Data/StateChange/DataItem/Context/DataItem/Property[@Name='Number of examined tables']$</TablesCount>

    <TableSize>$Data/StateChange/DataItem/Context/DataItem/Property[@Name='Minimal Table Size']$</TableSize>

    <Threshold>$Data/StateChange/DataItem/Context/DataItem/Property[@Name='Upper Threshold']$</Threshold>

    <TimeoutSeconds>600</TimeoutSeconds>

  </ProbeAction>

</Diagnostic>