Monitor Random Password Manager main database's connections and size.
Monitor 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 you set up the Random Password Manager SQL Authentication Account correctly if you use SQL Authentication.
It is recommended to set up the database autogrowth policy to be true.
Target | LiebermanSoftware.RPMMP.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.RPMMP.DBUnitMonitorType | ||
Remotable | True | ||
Accessibility | Internal | ||
Alert Message |
| ||
RunAs | Default |
<UnitMonitor ID="LiebermanSoftware.RPMMP.MainDBUnitMonitor" Accessibility="Internal" Enabled="false" Target="LiebermanSoftware.RPMMP.APP" ParentMonitorID="SystemHealth!System.Health.AvailabilityState" Remotable="true" Priority="Normal" TypeID="LiebermanSoftware.RPMMP.DBUnitMonitorType" ConfirmDelivery="true">
<Category>Custom</Category>
<AlertSettings AlertMessage="LiebermanSoftware.RPMMP.MainDBUnitMonitor_AlertMessageResourceID">
<AlertOnState>Error</AlertOnState>
<AutoResolve>true</AutoResolve>
<AlertPriority>Normal</AlertPriority>
<AlertSeverity>Error</AlertSeverity>
<AlertParameters>
<AlertParameter1>$Target/Property[Type="LiebermanSoftware.RPMMP.APP"]/DBDataSource$</AlertParameter1>
<AlertParameter2>$Target/Property[Type="LiebermanSoftware.RPMMP.APP"]/DBInitCatalog$</AlertParameter2>
</AlertParameters>
</AlertSettings>
<OperationalStates>
<OperationalState ID="LiebermanSoftware.RPMMP.MainDBUnitMonitor_SUCCESS" MonitorTypeStateID="Success" HealthState="Success"/>
<OperationalState ID="LiebermanSoftware.RPMMP.MainDBUnitMonitor_ERROR" MonitorTypeStateID="Error" HealthState="Error"/>
</OperationalStates>
<Configuration>
<DBSource>$Target/Property[Type="LiebermanSoftware.RPMMP.APP"]/DBDataSource$</DBSource>
<DBName>$Target/Property[Type="LiebermanSoftware.RPMMP.APP"]/DBInitCatalog$</DBName>
<SQLUserName/>
<SQLPassword/>
<DBPercent>90</DBPercent>
<IntervalSeconds>300</IntervalSeconds>
<TimeoutSeconds>300</TimeoutSeconds>
</Configuration>
</UnitMonitor>