Monitors connectivity between the Runbook Worker server and the database.
Monitors database connectivity from Runbook Worker servers. This is done by periodically making a test connection to the Service Management Automation database.
If this monitor is in error, then either the database is not available from the server or the security for the monitor is not configured correctly. See the Configuration section for details on configuring the monitor.
If the monitor is configured correctly and the monitor is in error then the database is offline or the database server is inaccessible to the Service Management Automation server.
Check the status of the Service Management Automation database and the database server.
For this monitor to work correctly, it must have permission to read the Service Management Automation database. Create a Run As Account that has read permissions to the database and add it to the Run As Profile called Microsoft Service Management Automation Database Account.
The following options can be configured on this monitor:
Option | Definition | Default |
Alert On State | Health state for the monitor that generates an alert. | The monitor is in a critical health state |
Alert Priority | Priority of the alert generated for this monitor. | Medium |
Alert Severity | Priority of the alert generated for this monitor. | Critical |
Auto-Resolve Alert | Specifies whether the alert should automatically be resolved when the monitor returns to a healthy state. | True |
Enabled | Specifies whether the monitor should run. | True |
Generates Alert | Specifies whether the monitor should generate an alert when changing to a warning or critical state. | True |
Interval | Number of seconds between times that the monitor is run. | 300 |
Target | Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.Server.Worker | ||
Parent Monitor | System.Health.AvailabilityState | ||
Category | AvailabilityHealth | ||
Enabled | True | ||
Alert Generate | True | ||
Alert Severity | Error | ||
Alert Priority | Normal | ||
Alert Auto Resolve | True | ||
Monitor Type | Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.MonitorType.DatabaseConnection | ||
Remotable | True | ||
Accessibility | Public | ||
Alert Message |
| ||
RunAs | Default |
<UnitMonitor ID="Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.Monitor.DatabaseConnectionWorker" Accessibility="Public" Enabled="true" Target="Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.Server.Worker" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal" TypeID="Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.MonitorType.DatabaseConnection" ConfirmDelivery="false">
<Category>AvailabilityHealth</Category>
<AlertSettings AlertMessage="Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.Monitor.DatabaseConnectionWorker.AlertMessage">
<AlertOnState>Error</AlertOnState>
<AutoResolve>true</AutoResolve>
<AlertPriority>Normal</AlertPriority>
<AlertSeverity>Error</AlertSeverity>
</AlertSettings>
<OperationalStates>
<OperationalState ID="ConnectionFailure" MonitorTypeStateID="ConnectionFailure" HealthState="Error"/>
<OperationalState ID="NoConnectionFailure" MonitorTypeStateID="NoConnectionFailure" HealthState="Success"/>
</OperationalStates>
<Configuration>
<Interval>300</Interval>
<DatabaseServer>$Target/Property[Type="SMA!Microsoft.SystemCenter.ServiceManagementAutomation.Server"]/DatabaseServerName$</DatabaseServer>
<DatabaseInstance>$Target/Property[Type="SMA!Microsoft.SystemCenter.ServiceManagementAutomation.Server"]/DatabaseServerInstance$</DatabaseInstance>
<DatabaseName>$Target/Property[Type="SMA!Microsoft.SystemCenter.ServiceManagementAutomation.Server"]/DatabaseName$</DatabaseName>
</Configuration>
</UnitMonitor>