This monitor checks the status of the SQL Browser Service.
This monitor checks the state of the SQL Browser Windows Service on the computer hosting the SQL DB Engine.
"Not Running" state of this monitor indicates that SQL Browser service is configured to start automatically but was detected to be in the "Stopped" state.
In general, a windows service could be stopped 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.
You can attempt to restart the service using the following link:
Start SQL Browser service
You can view other alerts for this instance of SQL Server that may be related to this issue using the following link:
View SQL Server Alerts
Target | Microsoft.SQLServer.2008.DBEngine | ||
Parent Monitor | System.Health.AvailabilityState | ||
Category | AvailabilityHealth | ||
Enabled | True | ||
Alert Generate | True | ||
Alert Severity | MatchMonitorHealth | ||
Alert Priority | Normal | ||
Alert Auto Resolve | True | ||
Monitor Type | Microsoft.Windows.CheckNTServiceStateMonitorType | ||
Remotable | True | ||
Accessibility | Public | ||
Alert Message |
| ||
RunAs | Default |
<UnitMonitor ID="Microsoft.SQLServer.2008.DBEngine.SQLBrowserService.UnitMonitor" Accessibility="Public" Enabled="true" Target="SQL2008Discovery!Microsoft.SQLServer.2008.DBEngine" ParentMonitorID="SystemHealth!System.Health.AvailabilityState" Remotable="true" Priority="Normal" TypeID="Windows!Microsoft.Windows.CheckNTServiceStateMonitorType" ConfirmDelivery="false">
<Category>AvailabilityHealth</Category>
<AlertSettings AlertMessage="Microsoft.SQLServer.2008.DBEngine.SQLBrowserService.UnitMonitor.Alert.Message">
<AlertOnState>Error</AlertOnState>
<AutoResolve>true</AutoResolve>
<AlertPriority>Normal</AlertPriority>
<AlertSeverity>MatchMonitorHealth</AlertSeverity>
<AlertParameters>
<AlertParameter1>$Data/Context/Property[@Name='Name']$</AlertParameter1>
<AlertParameter2>$Data/Context/Property[@Name='State']$</AlertParameter2>
<AlertParameter3>$Data/Context/LoggingComputer$</AlertParameter3>
<AlertParameter4>$Data/Context/@time$</AlertParameter4>
</AlertParameters>
</AlertSettings>
<OperationalStates>
<OperationalState ID="Success" MonitorTypeStateID="Running" HealthState="Success"/>
<OperationalState ID="Error" MonitorTypeStateID="NotRunning" HealthState="Error"/>
</OperationalStates>
<Configuration>
<ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<ServiceName>SQLBrowser</ServiceName>
<CheckStartupType/>
</Configuration>
</UnitMonitor>