Home
  •  

Servizio Windows SQL Server

Microsoft.SQLServer.2008.Database.ServiceMonitor (UnitMonitor)

Questo monitoraggio controlla lo stato del servizio del motore di database di SQL Server.

Knowledge Base article:

Riepilogo

Questo monitoraggio converte lo stato del monitoraggio del servizio Windows SQL Server del motore di database in un database. Per ulteriori informazioni, vedere l'articolo della Knowledge Base relativo al monitoraggio del servizio Windows SQL Server.

Element properties:

TargetMicrosoft.SQLServer.2008.Database
Parent MonitorSystem.Health.AvailabilityState
CategoryAvailabilityHealth
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveTrue
Monitor TypeMicrosoft.SQLServer.2008.CheckDBEngineServiceStateMonitorType
RemotableTrue
AccessibilityPublic
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.SQLServer.2008.Database.ServiceMonitor" Accessibility="Public" Enabled="true" Target="SQL2008Core!Microsoft.SQLServer.2008.Database" ParentMonitorID="SystemHealth!System.Health.AvailabilityState" Remotable="true" Priority="Normal" TypeID="Microsoft.SQLServer.2008.CheckDBEngineServiceStateMonitorType" ConfirmDelivery="false">

  <Category>AvailabilityHealth</Category>

  <OperationalStates>

    <OperationalState ID="Success" MonitorTypeStateID="Running" HealthState="Success"/>

    <OperationalState ID="Error" MonitorTypeStateID="NotRunning" HealthState="Error"/>

  </OperationalStates>

  <Configuration>

    <Frequency>60</Frequency>

    <ServiceName>$Target/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$</ServiceName>

  </Configuration>

</UnitMonitor>