Home
  •  

SQL 寫入器服務可用性監視

Microsoft.SystemCenter2012.ConfigurationManager.SqlWriter.ServiceHealth (UnitMonitor)

此監視會檢查 SQL 寫入器服務的可用性。

Knowledge Base article:

摘要

此監視會檢查SQL Server VSS 寫入器服務 (SQLWriter) 的狀態。 如果您接收到此監視的警示，則需要採取動作才能讓服務恢復操作狀態。

原因

服務可能會因許多原因而停止，其中包括：

解決方式

若 SQL Server VSS 寫入器服務並未執行，您可以採取下列動作來診斷問題或重新啟動服務：

Element properties:

TargetMicrosoft.SystemCenter2012.ConfigurationManager.SqlServer
Parent MonitorMicrosoft.SystemCenter2012.ConfigurationManager.RoleAggregateMonitor
CategoryAvailabilityHealth
EnabledTrue
Alert GenerateTrue
Alert SeverityMatchMonitorHealth
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeMicrosoft.Windows.CheckNTServiceStateMonitorType
RemotableTrue
AccessibilityPublic
Alert Message
SQL 寫入器服務未執行
電腦 {1} 上的 {0} 服務並未執行。
RunAsDefault
CommentSIV:BR0006

Source Code:

<UnitMonitor ID="Microsoft.SystemCenter2012.ConfigurationManager.SqlWriter.ServiceHealth" Comment="SIV:BR0006" Accessibility="Public" Enabled="onEssentialMonitoring" Target="SCCM!Microsoft.SystemCenter2012.ConfigurationManager.SqlServer" ParentMonitorID="Microsoft.SystemCenter2012.ConfigurationManager.RoleAggregateMonitor" Remotable="true" Priority="Normal" TypeID="Windows!Microsoft.Windows.CheckNTServiceStateMonitorType" ConfirmDelivery="false">

  <Category>AvailabilityHealth</Category>

  <AlertSettings AlertMessage="Microsoft.SystemCenter2012.ConfigurationManager.SqlWriter.ServiceHealth_AlertMessageResourceID">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>MatchMonitorHealth</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>

    <CheckStartupType/>

  </Configuration>

</UnitMonitor>