Diagnostik för SQL Broker

Microsoft.SystemCenter.SqlBrokerAvailabilityDiagnostic (Diagnostic)

Kontrollerar SQL Brokers aktiverade tillstånd.

Element properties:

Member Modules:

Source Code:

<Diagnostic ID="Microsoft.SystemCenter.SqlBrokerAvailabilityDiagnostic" Accessibility="Public" Enabled="false" Target="SCLibrary!Microsoft.SystemCenter.RootManagementServer" Monitor="Microsoft.SystemCenter.SqlBrokerAvailabilityMonitor" ExecuteOnState="Error" Remotable="true" Timeout="300">

  <Category>Maintenance</Category>

  <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\Microsoft Operations Manager\3.0\Setup\DatabaseName</DatabaseNameRegLocation>

    <DatabaseServerNameRegLocation>SOFTWARE\Microsoft\Microsoft Operations Manager\3.0\Setup\DatabaseServerName</DatabaseServerNameRegLocation>

  </ProbeAction>

</Diagnostic>