Monitor Enterprise Random Password Manager compliance database's Connection and Size
Monitor Enterprise Random Password Manager main database's connections and size.
This two state monitor will raise alert when
1.The database can not be opened
2.The database is not set to auto growth or its size is almost full (set by DBPercent)
Ensure agent action account have the right to access the database if you use Windows Authentication.
Ensure the Enterprise Random Password Manager SQL Authentication Account is correct if you use SQL Authentication.
It is recommended to set up the database autogrowth policy to be true.
Target | LiebermanSoftware.ERPMMP.APP | ||
Parent Monitor | System.Health.AvailabilityState | ||
Category | Custom | ||
Enabled | False | ||
Alert Generate | True | ||
Alert Severity | Error | ||
Alert Priority | Normal | ||
Alert Auto Resolve | True | ||
Monitor Type | LiebermanSoftware.ERPMMP.DBUnitMonitorType | ||
Remotable | True | ||
Accessibility | Internal | ||
Alert Message |
| ||
RunAs | Default |
<UnitMonitor ID="LiebermanSoftware.ERPMMP.CDBUnitMonitor" Accessibility="Internal" Enabled="false" Target="LiebermanSoftware.ERPMMP.APP" ParentMonitorID="SystemHealth!System.Health.AvailabilityState" Remotable="true" Priority="Normal" TypeID="LiebermanSoftware.ERPMMP.DBUnitMonitorType" ConfirmDelivery="true">
<Category>Custom</Category>
<AlertSettings AlertMessage="LiebermanSoftware.ERPMMP.CDBUnitMonitor_AlertMessageResourceID">
<AlertOnState>Error</AlertOnState>
<AutoResolve>true</AutoResolve>
<AlertPriority>Normal</AlertPriority>
<AlertSeverity>Error</AlertSeverity>
<AlertParameters>
<AlertParameter1>$Target/Property[Type="LiebermanSoftware.ERPMMP.APP"]/CDBDataSource$</AlertParameter1>
<AlertParameter2>$Target/Property[Type="LiebermanSoftware.ERPMMP.APP"]/CDBInitCatalog$</AlertParameter2>
</AlertParameters>
</AlertSettings>
<OperationalStates>
<OperationalState ID="LiebermanSoftware.ERPMMP.CDBUnitMonitor_SUCCESS" MonitorTypeStateID="Success" HealthState="Success"/>
<OperationalState ID="LiebermanSoftware.ERPMMP.CDBUnitMonitor_ERROR" MonitorTypeStateID="Error" HealthState="Error"/>
</OperationalStates>
<Configuration>
<DBSource>$Target/Property[Type="LiebermanSoftware.ERPMMP.APP"]/CDBDataSource$</DBSource>
<DBName>$Target/Property[Type="LiebermanSoftware.ERPMMP.APP"]/CDBInitCatalog$</DBName>
<SQLUserName/>
<SQLPassword/>
<DBPercent>90</DBPercent>
<IntervalSeconds>300</IntervalSeconds>
<TimeoutSeconds>300</TimeoutSeconds>
</Configuration>
</UnitMonitor>