This monitor checks the availability of SQL Writer Service.
This monitor checks the status of the SQL Server VSS Writer service (SQLWriter). If you receive an alert from this monitor, action is required to bring the service back to an operational state.
A service can stop for many reasons, including:
The service was stopped by an administrator.
The service was prevented from starting because the user account could not be authenticated.
The service encountered an exception that stopped the service.
The service was improperly configured, which prevented it from starting.
If the SQL Server VSS Writer service is not running you can diagnose the issue or restart the service by taking the following actions:
Check for additional service-related alerts that might have occurred concurrently. These alerts might help better identify the reason why the service is not running.
Review the event logs on the managed computer, and correct any underlying problems that might have caused the service to stop unexpectedly.
Restart the service.
| Target | MECM.SQLServer | ||
| Parent Monitor | MECM.SiteRole.AggregateRollup.Monitor | ||
| Category | AvailabilityHealth | ||
| Enabled | True | ||
| Alert Generate | True | ||
| Alert Severity | Error | ||
| Alert Priority | Normal | ||
| Alert Auto Resolve | True | ||
| Monitor Type | MECM.Service.MT | ||
| Remotable | True | ||
| Accessibility | Public | ||
| Alert Message |
| ||
| RunAs | Default |
Home
<UnitMonitor ID="MECM.SqlWriter.Service.Monitor" Accessibility="Public" Enabled="true" Target="MECM.SQLServer" ParentMonitorID="MECM.SiteRole.AggregateRollup.Monitor" Remotable="true" Priority="Normal" TypeID="MECM.Service.MT" ConfirmDelivery="false">
<Category>AvailabilityHealth</Category>
<AlertSettings AlertMessage="MECM.SqlWriter.Service.Monitor.AlertMessage">
<AlertOnState>Error</AlertOnState>
<AutoResolve>true</AutoResolve>
<AlertPriority>Normal</AlertPriority>
<AlertSeverity>Error</AlertSeverity>
<AlertParameters>
<AlertParameter1>$Data/Context/Property[@Name='DisplayName']$</AlertParameter1>
<AlertParameter2>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/PrincipalName$</AlertParameter2>
</AlertParameters>
</AlertSettings>
<OperationalStates>
<OperationalState ID="Running" MonitorTypeStateID="Running" HealthState="Success"/>
<OperationalState ID="NotRunning" MonitorTypeStateID="NotRunning" HealthState="Error"/>
</OperationalStates>
<Configuration>
<ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/PrincipalName$</ComputerName>
<ServiceName>SQLWriter</ServiceName>
<IntervalSeconds>120</IntervalSeconds>
<MatchCount>5</MatchCount>
</Configuration>
</UnitMonitor>