Indexes Missing in DB
ozsoft.sap.Monitor.MSSQL.ItemsMissingInDB.Indexes (UnitMonitor)
Number of Indexes Missing in DB
Element properties:
Source Code:
<UnitMonitor ID="ozsoft.sap.Monitor.MSSQL.ItemsMissingInDB.Indexes" Accessibility="Public" Enabled="false" Target="ozsoft.sap.MSSQL" ParentMonitorID="Health!System.Health.ConfigurationState" Remotable="true" Priority="Normal" TypeID="ozsoft.sap.CCMSMetricMonitorType2" ConfirmDelivery="false">
<Category>Operations</Category>
<AlertSettings AlertMessage="ozsoft.sap.Monitor.MSSQL.ItemsMissingInDB.Indexes.AlertMessageResourceID">
<AlertOnState>Warning</AlertOnState>
<AutoResolve>true</AutoResolve>
<AlertPriority>Normal</AlertPriority>
<AlertSeverity>MatchMonitorHealth</AlertSeverity>
<AlertParameters>
<AlertParameter1>$Data/Context/ObjectName$</AlertParameter1>
<AlertParameter2>$Data/Context/CounterName$</AlertParameter2>
<AlertParameter3>$Data/Context/Value$</AlertParameter3>
</AlertParameters>
</AlertSettings>
<OperationalStates>
<OperationalState ID="Under" MonitorTypeStateID="SDKMetricUnderLowThreshold" HealthState="Success"/>
<OperationalState ID="Between" MonitorTypeStateID="SDKMetricUnderHighOverLowThreshold" HealthState="Warning"/>
<OperationalState ID="Over" MonitorTypeStateID="SDKMetricOverHighThreshold" HealthState="Error"/>
</OperationalStates>
<Configuration>
<CounterName>Indexes</CounterName>
<ObjectName>Items Missing in DB</ObjectName>
<Frequency>3600</Frequency>
<HighThreshold>3</HighThreshold>
<LowThreshold>2</LowThreshold>
</Configuration>
</UnitMonitor>