FingerprintDatabaseFragmentation.Monitor

Veritas.EnterpriseVault.12.FingerprintDatabaseFragmentation.Monitor (UnitMonitor)

Monitors the fragmentation state of the Fingerprint database.

Knowledge Base article:

Summary

Fingerprint Database is fragmented.

Causes

The increase in fragmentation is expected.

Resolutions

1. To determine which indexes to defragment, arrange for your database administrator to run the 'ReadFragmentationResults' stored procedure. See How to run the 'ReadFragmentationResults' stored procedure?

2. Arrange for your database administrator to rebuild or reorganize the fragmented indexes.

3. Run the ‘ComputeFragmentation’ stored procedure to update the results. See How to run the 'ComputeFragmentation' stored procedure?

4. To check that the problem has been corrected, go to the Status section of the Administration Console and run the checks again.

To prevent the problem from recurring, ensure that SQL maintenance is performed regularly.

External

See 'Veritas Enterprise Vault: SQL Best Practices Guides'

Element properties:

Target

Veritas.EnterpriseVault.12.FingerprintDatabaseFragmentation.Hosted

Parent Monitor

System.Health.AvailabilityState

Category

AvailabilityHealth

Enabled

True

Alert Generate

True

Alert Severity

MatchMonitorHealth

Alert Priority

Normal

Alert Auto Resolve

True

Monitor Type

Microsoft.Windows.2SingleEventLog2StateMonitorType

Remotable

True

Accessibility

Internal

Alert Message

Fingerprint database is fragmented

{0}

RunAs

Veritas.EnterpriseVault.MonitoringProfile

Source Code:

<UnitMonitor ID="Veritas.EnterpriseVault.12.FingerprintDatabaseFragmentation.Monitor" Accessibility="Internal" Enabled="true" Target="Veritas.EnterpriseVault.12.FingerprintDatabaseFragmentation.Hosted" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal" TypeID="Windows!Microsoft.Windows.2SingleEventLog2StateMonitorType" ConfirmDelivery="false" RunAs="EV!Veritas.EnterpriseVault.MonitoringProfile">

  <Category>AvailabilityHealth</Category>

  <AlertSettings AlertMessage="Veritas.EnterpriseVault.12.FingerprintDatabaseFragmentation.Monitor.AlertMessage">

    <AlertOnState>Warning</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>MatchMonitorHealth</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Data/Context/EventData/DataItem$</AlertParameter1>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

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

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

  </OperationalStates>

  <Configuration>

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

    <FirstLogName>Application</FirstLogName>

    <FirstExpression>

      <And>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery Type="UnsignedInteger">EventDisplayNumber</XPathQuery>

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value Type="UnsignedInteger">41560</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery Type="String">PublisherName</XPathQuery>

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value Type="String">Enterprise Vault</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

        <Expression>

          <RegExExpression>

            <ValueExpression>

              <XPathQuery Type="String">EventDescription</XPathQuery>

            </ValueExpression>

            <Operator>ContainsSubstring</Operator>

            <Pattern>$Target/Property[Type="Veritas.EnterpriseVault.12.DatabaseFragmentation"]/DatabaseName$</Pattern>

          </RegExExpression>

        </Expression>

      </And>

    </FirstExpression>

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

    <SecondLogName>Application</SecondLogName>

    <SecondExpression>

      <And>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery Type="UnsignedInteger">EventDisplayNumber</XPathQuery>

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value Type="UnsignedInteger">41561</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery Type="String">PublisherName</XPathQuery>

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value Type="String">Enterprise Vault</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

        <Expression>

          <RegExExpression>

            <ValueExpression>

              <XPathQuery Type="String">EventDescription</XPathQuery>

            </ValueExpression>

            <Operator>ContainsSubstring</Operator>

            <Pattern>$Target/Property[Type="Veritas.EnterpriseVault.12.DatabaseFragmentation"]/DatabaseName$</Pattern>

          </RegExExpression>

        </Expression>

      </And>

    </SecondExpression>

  </Configuration>

</UnitMonitor>