Type d'analyse de la disponibilité de SQL Broker
Microsoft.ServiceManager.SqlBrokerAvailabilityMonitorType (UnitMonitorType)
Type d'analyse vérifiant l'état de SQL Broker pour les fonctionnalités d'Operations Manager.
Element properties:
Member Modules:
Source Code:
<UnitMonitorType ID="Microsoft.ServiceManager.SqlBrokerAvailabilityMonitorType" Accessibility="Internal" RunAs="SM!Microsoft.SystemCenter.ServiceManager.DatabaseWriteActionAccount">
<MonitorTypeStates>
<MonitorTypeState ID="SqlBrokerEnabled" NoDetection="false"/>
<MonitorTypeState ID="SqlBrokerDisabled" NoDetection="false"/>
</MonitorTypeStates>
<Configuration/>
<MonitorImplementation>
<MemberModules>
<DataSource ID="Scheduler" TypeID="System!System.Scheduler">
<Scheduler>
<SimpleReccuringSchedule>
<Interval Unit="Seconds">10</Interval>
</SimpleReccuringSchedule>
<ExcludeDates/>
</Scheduler>
</DataSource>
<ProbeAction ID="OleDbProbe" TypeID="System!System.OleDbTriggerProbe">
<ConnectionString>Provider=SQLOLEDB;Integrated Security=SSPI</ConnectionString>
<Query>SELECT cast(is_broker_enabled as int) FROM sys.databases WHERE name = DB_Name()</Query>
<GetValue>true</GetValue>
<OneRowPerItem>true</OneRowPerItem>
<DatabaseNameRegLocation>SOFTWARE\Microsoft\System Center\2010\Common\Database\DatabaseName</DatabaseNameRegLocation>
<DatabaseServerNameRegLocation>SOFTWARE\Microsoft\System Center\2010\Common\Database\DatabaseServerName</DatabaseServerNameRegLocation>
</ProbeAction>
<ConditionDetection ID="CDEnabled" TypeID="System!System.ExpressionFilter">
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="Integer">Columns[1]/Column[1]</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value Type="Integer">1</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
</ConditionDetection>
<ConditionDetection ID="CDDisabled" TypeID="System!System.ExpressionFilter">
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="Integer">Columns[1]/Column[1]</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value Type="Integer">0</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
</ConditionDetection>
</MemberModules>
<RegularDetections>
<RegularDetection MonitorTypeStateID="SqlBrokerEnabled">
<Node ID="CDEnabled">
<Node ID="OleDbProbe">
<Node ID="Scheduler"/>
</Node>
</Node>
</RegularDetection>
<RegularDetection MonitorTypeStateID="SqlBrokerDisabled">
<Node ID="CDDisabled">
<Node ID="OleDbProbe">
<Node ID="Scheduler"/>
</Node>
</Node>
</RegularDetection>
</RegularDetections>
<OnDemandDetections>
<OnDemandDetection MonitorTypeStateID="SqlBrokerEnabled">
<Node ID="CDEnabled">
<Node ID="OleDbProbe"/>
</Node>
</OnDemandDetection>
<OnDemandDetection MonitorTypeStateID="SqlBrokerDisabled">
<Node ID="CDDisabled">
<Node ID="OleDbProbe"/>
</Node>
</OnDemandDetection>
</OnDemandDetections>
</MonitorImplementation>
</UnitMonitorType>