Vault Store saveset index check

Veritas.EnterpriseVault.12.StorageService.SQL_indexing_missing_saveset.Rule (Rule)

Knowledge Base article:

Summary

If you run Centera collections, performance may degrade because of growth in the Saveset table in the Vault Store database.

Causes

For best performance Enterprise Vault creates a SQL index on the Vault Store Saveset table. This warning is logged because Enterprise Vault cannot create the index.

Resolutions

To resolve the problem, create the index manually as described in the following technical note:

http://www.veritas.com/docs/TECH51231

External

Veritas Event Database

Element properties:

Target	Veritas.EnterpriseVault.12.StorageService
Category	EventCollection
Enabled	True
Alert Generate	False
Remotable	True

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Veritas.EnterpriseVault.12.EventProvider.DataSourceModuleType	Veritas.EnterpriseVault.MonitoringProfile
WriteToDB	WriteAction	Microsoft.SystemCenter.CollectEvent	Veritas.EnterpriseVault.MonitoringProfile
WriteToDW	WriteAction	Microsoft.SystemCenter.DataWarehouse.PublishEventData	Veritas.EnterpriseVault.MonitoringProfile

Source Code:

<Rule ID="Veritas.EnterpriseVault.12.StorageService.SQL_indexing_missing_saveset.Rule" Target="Veritas.EnterpriseVault.12.StorageService" Enabled="true" ConfirmDelivery="true" Remotable="true" Priority="Normal" DiscardLevel="100">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="DS" TypeID="Veritas.EnterpriseVault.12.EventProvider.DataSourceModuleType" RunAs="EV!Veritas.EnterpriseVault.MonitoringProfile">

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

      <EventNumber>7162</EventNumber>

      <LogName>Application</LogName>

      <EventSourceName>Enterprise Vault</EventSourceName>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="WriteToDB" TypeID="SC!Microsoft.SystemCenter.CollectEvent" RunAs="EV!Veritas.EnterpriseVault.MonitoringProfile"/>

    <WriteAction ID="WriteToDW" TypeID="MSDL!Microsoft.SystemCenter.DataWarehouse.PublishEventData" RunAs="EV!Veritas.EnterpriseVault.MonitoringProfile"/>

  </WriteActions>

</Rule>