Fonte de Dados de Comprimento da Fila de Mensagens do Service Management Automation
Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.DataSource.MessageQueueLength (DataSourceModuleType)
Módulo de fonte de dados que faz a conexão com o banco de dados e coleta o número de registros na tabela Fila de Mensagens.
Element properties:
Member Modules:
Overrideable Parameters:
Source Code:
<DataSourceModuleType ID="Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.DataSource.MessageQueueLength" RunAs="Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.DatabaseAccount" Accessibility="Internal" Batching="false">
<Configuration>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" minOccurs="1" name="Interval" type="xsd:integer"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" minOccurs="1" name="DatabaseServer" type="xsd:string"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" minOccurs="1" name="DatabaseInstance" type="xsd:string"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" minOccurs="1" name="DatabaseName" type="xsd:string"/>
</Configuration>
<OverrideableParameters>
<OverrideableParameter ID="Interval" Selector="$Config/Interval$" ParameterType="int"/>
</OverrideableParameters>
<ModuleImplementation Isolation="Any">
<Composite>
<MemberModules>
<DataSource ID="DB" TypeID="Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.DataSource.DatabaseQuery">
<Interval>$Config/Interval$</Interval>
<DatabaseServer>$Config/DatabaseServer$</DatabaseServer>
<DatabaseInstance>$Config/DatabaseInstance$</DatabaseInstance>
<DatabaseName>$Config/DatabaseName$</DatabaseName>
<Query>select count(*) from Queues.Message</Query>
</DataSource>
<ConditionDetection ID="DBConnection" TypeID="System!System.ExpressionFilter">
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="Integer">HRResult</XPathQuery>
</ValueExpression>
<Operator>GreaterEqual</Operator>
<ValueExpression>
<Value Type="Integer">0</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
</ConditionDetection>
<ConditionDetection ID="MapToPerf" TypeID="Performance!System.Performance.DataGenericMapper">
<ObjectName>Orchestrator Worker Performance Counters</ObjectName>
<CounterName>Message Queue Length</CounterName>
<InstanceName/>
<Value>$Data/Columns/Column$</Value>
</ConditionDetection>
</MemberModules>
<Composition>
<Node ID="MapToPerf">
<Node ID="DBConnection">
<Node ID="DB"/>
</Node>
</Node>
</Composition>
</Composite>
</ModuleImplementation>
<OutputType>Performance!System.Performance.Data</OutputType>
</DataSourceModuleType>