MSSQL 2008: Verificação da Configuração do Banco de Dados

Microsoft.SQLServer.2008.DBConfigurationStatus (UnitMonitorType)

Este tipo de monitor verifica um valor de configuração de banco de dados conhecido tomando como base um valor especificado esperado.
Element properties:

Show References:
- Unit Monitors (9)
RunAs	Default
Accessibility	Internal
Support Monitor Recalculate	False
Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.SQLServer.2008.DBConfigurationProvider	Default
FilterBad	ConditionDetection	System.ExpressionFilter	Default
FilterGood	ConditionDetection	System.ExpressionFilter	Default
Overrideable Parameters:

ID	ParameterType	Selector	Display Name	Description
IntervalSeconds	int	$Config/IntervalSeconds$	Intervalo (segundos)	O intervalo recorrente de tempo em segundos durante o qual executar o fluxo de trabalho.
ExpectedValue	string	$Config/ExpectedValue$	Valor Esperado	Para exibir o conjunto de valores possíveis, consulte a seção "Configuração" estando a par deste monitor.
ExcludeOnExpress	bool	$Config/ExcludeOnExpress$	Desabilitar Verificação para SQL Express	Habilita ou desabilita a verificação de versão do SQL Express.
TimeoutSeconds	int	$Config/TimeoutSeconds$	Tempo Limite (segundos)	Especifica o tempo durante o qual o fluxo de trabalho pode ser executado antes de ser fechado e marcado como com falha.
Source Code:

<UnitMonitorType ID="Microsoft.SQLServer.2008.DBConfigurationStatus" Accessibility="Internal">

  <MonitorTypeStates>

    <MonitorTypeState ID="ConfigurationValueOK"/>

    <MonitorTypeState ID="ConfigurationValueNotOK"/>

  </MonitorTypeStates>

  <Configuration>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="ConnectionString" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="DatabaseName" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="IntervalSeconds" type="xsd:int"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="SyncTime" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="ConfigValue" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="ExpectedValue" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="ExcludeOnExpress" type="xsd:boolean"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="SQLSKU" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="TimeoutSeconds" type="xsd:int"/>

  </Configuration>

  <OverrideableParameters>

    <OverrideableParameter ID="IntervalSeconds" ParameterType="int" Selector="$Config/IntervalSeconds$"/>

    <OverrideableParameter ID="ExpectedValue" ParameterType="string" Selector="$Config/ExpectedValue$"/>

    <OverrideableParameter ID="ExcludeOnExpress" ParameterType="bool" Selector="$Config/ExcludeOnExpress$"/>

    <OverrideableParameter ID="TimeoutSeconds" ParameterType="int" Selector="$Config/TimeoutSeconds$"/>

  </OverrideableParameters>

  <MonitorImplementation>

    <MemberModules>

      <DataSource TypeID="Microsoft.SQLServer.2008.DBConfigurationProvider" ID="DS">

        <IntervalSeconds>$Config/IntervalSeconds$</IntervalSeconds>

        <SyncTime>$Config/SyncTime$</SyncTime>

        <ConnectionString>$Config/ConnectionString$</ConnectionString>

        <TimeoutSeconds>$Config/TimeoutSeconds$</TimeoutSeconds>

      </DataSource>

      <ConditionDetection ID="FilterGood" TypeID="System!System.ExpressionFilter">

        <Expression>

          <And>

            <Expression>

              <Or>

                <Expression>

                  <SimpleExpression>

                    <ValueExpression>

                      <XPathQuery Type="String">Property[@Name='$Config/DatabaseName$-$Config/ConfigValue$']</XPathQuery>

                    </ValueExpression>

                    <Operator>Equal</Operator>

                    <ValueExpression>

                      <Value Type="String">$Config/ExpectedValue$</Value>

                    </ValueExpression>

                  </SimpleExpression>

                </Expression>

                <!-- The following condition for backcompatibility with previoslly version MP -->

                <Expression>

                  <And>

                    <Expression>

                      <SimpleExpression>

                        <ValueExpression>

                          <Value Type="String">true</Value>

                        </ValueExpression>

                        <Operator>Equal</Operator>

                        <ValueExpression>

                          <Value Type="String">$Config/ExpectedValue$</Value>

                        </ValueExpression>

                      </SimpleExpression>

                    </Expression>

                    <Expression>

                      <SimpleExpression>

                        <ValueExpression>

                          <XPathQuery Type="String">Property[@Name='$Config/DatabaseName$-$Config/ConfigValue$']</XPathQuery>

                        </ValueExpression>

                        <Operator>Equal</Operator>

                        <ValueExpression>

                          <Value Type="String">TORN_PAGE_DETECTION</Value>

                        </ValueExpression>

                      </SimpleExpression>

                    </Expression>

                  </And>

                </Expression>

                <Expression>

                  <And>

                    <Expression>

                      <SimpleExpression>

                        <ValueExpression>

                          <Value Type="String">false</Value>

                        </ValueExpression>

                        <Operator>Equal</Operator>

                        <ValueExpression>

                          <Value Type="String">$Config/ExpectedValue$</Value>

                        </ValueExpression>

                      </SimpleExpression>

                    </Expression>

                    <Expression>

                      <SimpleExpression>

                        <ValueExpression>

                          <XPathQuery Type="String">Property[@Name='$Config/DatabaseName$-$Config/ConfigValue$']</XPathQuery>

                        </ValueExpression>

                        <Operator>Equal</Operator>

                        <ValueExpression>

                          <Value Type="String">NONE</Value>

                        </ValueExpression>

                      </SimpleExpression>

                    </Expression>

                  </And>

                </Expression>

                <Expression>

                  <And>

                    <Expression>

                      <SimpleExpression>

                        <ValueExpression>

                          <Value Type="String">true</Value>

                        </ValueExpression>

                        <Operator>Equal</Operator>

                        <ValueExpression>

                          <Value Type="String">$Config/ExpectedValue$</Value>

                        </ValueExpression>

                      </SimpleExpression>

                    </Expression>

                    <Expression>

                      <SimpleExpression>

                        <ValueExpression>

                          <XPathQuery Type="String">Property[@Name='$Config/DatabaseName$-$Config/ConfigValue$']</XPathQuery>

                        </ValueExpression>

                        <Operator>Equal</Operator>

                        <ValueExpression>

                          <Value Type="String">ON</Value>

                        </ValueExpression>

                      </SimpleExpression>

                    </Expression>

                  </And>

                </Expression>

                <Expression>

                  <And>

                    <Expression>

                      <SimpleExpression>

                        <ValueExpression>

                          <Value Type="String">false</Value>

                        </ValueExpression>

                        <Operator>Equal</Operator>

                        <ValueExpression>

                          <Value Type="String">$Config/ExpectedValue$</Value>

                        </ValueExpression>

                      </SimpleExpression>

                    </Expression>

                    <Expression>

                      <SimpleExpression>

                        <ValueExpression>

                          <XPathQuery Type="String">Property[@Name='$Config/DatabaseName$-$Config/ConfigValue$']</XPathQuery>

                        </ValueExpression>

                        <Operator>Equal</Operator>

                        <ValueExpression>

                          <Value Type="String">OFF</Value>

                        </ValueExpression>

                      </SimpleExpression>

                    </Expression>

                  </And>

                </Expression>

                <Expression>

                  <And>

                    <Expression>

                      <SimpleExpression>

                        <ValueExpression>

                          <Value Type="Boolean">$Config/ExcludeOnExpress$</Value>

                        </ValueExpression>

                        <Operator>Equal</Operator>

                        <ValueExpression>

                          <Value Type="Boolean">true</Value>

                        </ValueExpression>

                      </SimpleExpression>

                    </Expression>

                    <Expression>

                      <SimpleExpression>

                        <ValueExpression>

                          <Value Type="String">$Config/SQLSKU$</Value>

                        </ValueExpression>

                        <Operator>Equal</Operator>

                        <ValueExpression>

                          <Value Type="String">Express Edition</Value>

                        </ValueExpression>

                      </SimpleExpression>

                    </Expression>

                  </And>

                </Expression>

              </Or>

            </Expression>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery Type="String">Property[@Name='$Config/DatabaseName$-$Config/ConfigValue$']</XPathQuery>

                </ValueExpression>

                <Operator>NotEqual</Operator>

                <ValueExpression>

                  <Value Type="String">N/A</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

          </And>

        </Expression>

      </ConditionDetection>

      <ConditionDetection ID="FilterBad" TypeID="System!System.ExpressionFilter">

        <Expression>

          <And>

            <Expression>

              <Not>

                <Expression>

                  <Or>

                    <Expression>

                      <SimpleExpression>

                        <ValueExpression>

                          <XPathQuery Type="String">Property[@Name='$Config/DatabaseName$-$Config/ConfigValue$']</XPathQuery>

                        </ValueExpression>

                        <Operator>Equal</Operator>

                        <ValueExpression>

                          <Value Type="String">$Config/ExpectedValue$</Value>

                        </ValueExpression>

                      </SimpleExpression>

                    </Expression>

                    <!-- The following condition for backcompatibility with previoslly version MP -->

                    <Expression>

                      <And>

                        <Expression>

                          <SimpleExpression>

                            <ValueExpression>

                              <Value Type="String">true</Value>

                            </ValueExpression>

                            <Operator>Equal</Operator>

                            <ValueExpression>

                              <Value Type="String">$Config/ExpectedValue$</Value>

                            </ValueExpression>

                          </SimpleExpression>

                        </Expression>

                        <Expression>

                          <SimpleExpression>

                            <ValueExpression>

                              <XPathQuery Type="String">Property[@Name='$Config/DatabaseName$-$Config/ConfigValue$']</XPathQuery>

                            </ValueExpression>

                            <Operator>Equal</Operator>

                            <ValueExpression>

                              <Value Type="String">TORN_PAGE_DETECTION</Value>

                            </ValueExpression>

                          </SimpleExpression>

                        </Expression>

                      </And>

                    </Expression>

                    <Expression>

                      <And>

                        <Expression>

                          <SimpleExpression>

                            <ValueExpression>

                              <Value Type="String">false</Value>

                            </ValueExpression>

                            <Operator>Equal</Operator>

                            <ValueExpression>

                              <Value Type="String">$Config/ExpectedValue$</Value>

                            </ValueExpression>

                          </SimpleExpression>

                        </Expression>

                        <Expression>

                          <SimpleExpression>

                            <ValueExpression>

                              <XPathQuery Type="String">Property[@Name='$Config/DatabaseName$-$Config/ConfigValue$']</XPathQuery>

                            </ValueExpression>

                            <Operator>Equal</Operator>

                            <ValueExpression>

                              <Value Type="String">NONE</Value>

                            </ValueExpression>

                          </SimpleExpression>

                        </Expression>

                      </And>

                    </Expression>

                    <Expression>

                      <And>

                        <Expression>

                          <SimpleExpression>

                            <ValueExpression>

                              <Value Type="String">true</Value>

                            </ValueExpression>

                            <Operator>Equal</Operator>

                            <ValueExpression>

                              <Value Type="String">$Config/ExpectedValue$</Value>

                            </ValueExpression>

                          </SimpleExpression>

                        </Expression>

                        <Expression>

                          <SimpleExpression>

                            <ValueExpression>

                              <XPathQuery Type="String">Property[@Name='$Config/DatabaseName$-$Config/ConfigValue$']</XPathQuery>

                            </ValueExpression>

                            <Operator>Equal</Operator>

                            <ValueExpression>

                              <Value Type="String">ON</Value>

                            </ValueExpression>

                          </SimpleExpression>

                        </Expression>

                      </And>

                    </Expression>

                    <Expression>

                      <And>

                        <Expression>

                          <SimpleExpression>

                            <ValueExpression>

                              <Value Type="String">false</Value>

                            </ValueExpression>

                            <Operator>Equal</Operator>

                            <ValueExpression>

                              <Value Type="String">$Config/ExpectedValue$</Value>

                            </ValueExpression>

                          </SimpleExpression>

                        </Expression>

                        <Expression>

                          <SimpleExpression>

                            <ValueExpression>

                              <XPathQuery Type="String">Property[@Name='$Config/DatabaseName$-$Config/ConfigValue$']</XPathQuery>

                            </ValueExpression>

                            <Operator>Equal</Operator>

                            <ValueExpression>

                              <Value Type="String">OFF</Value>

                            </ValueExpression>

                          </SimpleExpression>

                        </Expression>

                      </And>

                    </Expression>

                    <Expression>

                      <And>

                        <Expression>

                          <SimpleExpression>

                            <ValueExpression>

                              <Value Type="Boolean">$Config/ExcludeOnExpress$</Value>

                            </ValueExpression>

                            <Operator>Equal</Operator>

                            <ValueExpression>

                              <Value Type="Boolean">true</Value>

                            </ValueExpression>

                          </SimpleExpression>

                        </Expression>

                        <Expression>

                          <SimpleExpression>

                            <ValueExpression>

                              <Value Type="String">$Config/SQLSKU$</Value>

                            </ValueExpression>

                            <Operator>Equal</Operator>

                            <ValueExpression>

                              <Value Type="String">Express Edition</Value>

                            </ValueExpression>

                          </SimpleExpression>

                        </Expression>

                      </And>

                    </Expression>

                  </Or>

                </Expression>

              </Not>

            </Expression>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery Type="String">Property[@Name='$Config/DatabaseName$-$Config/ConfigValue$']</XPathQuery>

                </ValueExpression>

                <Operator>NotEqual</Operator>

                <ValueExpression>

                  <Value Type="String">N/A</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

          </And>

        </Expression>

      </ConditionDetection>

    </MemberModules>

    <RegularDetections>

      <RegularDetection MonitorTypeStateID="ConfigurationValueOK">

        <Node ID="FilterGood">

          <Node ID="DS"/>

        </Node>

      </RegularDetection>

      <RegularDetection MonitorTypeStateID="ConfigurationValueNotOK">

        <Node ID="FilterBad">

          <Node ID="DS"/>

        </Node>

      </RegularDetection>

    </RegularDetections>

  </MonitorImplementation>

</UnitMonitorType>