Home
  •  

Blocking SPIDs

Microsoft.SQLServer.2008.DBEngine.BlockedSPIDsMonitor (UnitMonitor)

Knowledge Base article:

Summary

SQL 2008 Blocked SPID Monitor. Monitors blocked SPIDs.

Configuration

Element properties:

TargetMicrosoft.SQLServer.2008.DBEngine
Parent MonitorSystem.Health.PerformanceState
CategoryPerformanceHealth
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveTrue
Monitor TypeMicrosoft.SQLServer.2008.DBEngine.BlockedSPIDs
RemotableTrue
AccessibilityPublic
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.SQLServer.2008.DBEngine.BlockedSPIDsMonitor" Accessibility="Public" Enabled="true" Target="SQL2008Core!Microsoft.SQLServer.2008.DBEngine" ParentMonitorID="SystemHealth!System.Health.PerformanceState" Remotable="true" Priority="Normal" TypeID="Microsoft.SQLServer.2008.DBEngine.BlockedSPIDs" ConfirmDelivery="false">

  <Category>PerformanceHealth</Category>

  <OperationalStates>

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

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

  </OperationalStates>

  <Configuration>

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

    <IntervalSeconds>300</IntervalSeconds>

    <SyncTime/>

    <WaitMinutes>1</WaitMinutes>

    <NumberBlockedSPIDs>1</NumberBlockedSPIDs>

    <TimeoutSeconds>300</TimeoutSeconds>

    <InstanceName>$Target/Property[Type="SQL!Microsoft.SQLServer.ServerRole"]/InstanceName$</InstanceName>

    <ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

  </Configuration>

</UnitMonitor>