Home
  •  

Conflit de configuration avec le type d’analyse de SQL Server

Microsoft.SQLServer.2016.ReportingServices.MonitorType.Instance.ConfigurationConflictWithSQLServer (UnitMonitorType)

Conflit de configuration avec le type d’analyse de SQL Server pour Reporting Services

Element properties:

RunAsMicrosoft.SQLServer.MonitoringAccount
AccessibilityInternal
Support Monitor RecalculateFalse

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.SQLServer.2016.ReportingServices.DataSource.Memory Default
CDConfigurationConflict ConditionDetection System.ExpressionFilter Default
CDNoConfigurationConflict ConditionDetection System.ExpressionFilter Default
CDSQLServerInstalled ConditionDetection System.ExpressionFilter Default

Overrideable Parameters:

IDParameterTypeSelectorDisplay NameDescription
Thresholddouble$Config/Threshold$SeuilL’analyse modifie son état et enregistre une alerte si SSRS et SQL Server sont en cours d’exécution sur la même machine, et si la valeur de WorkingSetMaximum dépasse le seuil défini.
IntervalSecondsint$Config/IntervalSeconds$Intervalle (en secondes)L'intervalle de temps récurrent en secondes pendant lequel le workflow est exécuté.
SyncTimestring$Config/SyncTime$Heure de synchronisationL'heure de synchronisation spécifiée dans un format de 24 heures. Peut être omise.
TimeoutSecondsint$Config/TimeoutSeconds$Délai d'attente (secondes)Spécifie la durée pendant laquelle le workflow est autorisé à être exécuté avant d'être fermé et marqué comme un échec.

Source Code:

<UnitMonitorType ID="Microsoft.SQLServer.2016.ReportingServices.MonitorType.Instance.ConfigurationConflictWithSQLServer" Accessibility="Internal" RunAs="GPMP!Microsoft.SQLServer.MonitoringAccount">

  <MonitorTypeStates>

    <MonitorTypeState ID="ConfigurationConflict" NoDetection="false"/>

    <MonitorTypeState ID="NoConfigurationConflict" NoDetection="false"/>

    <MonitorTypeState ID="NoConflictNoSQLServer" NoDetection="false"/>

  </MonitorTypeStates>

  <Configuration>

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

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

    <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="TimeoutSeconds" type="xsd:integer"/>

  </Configuration>

  <OverrideableParameters>

    <OverrideableParameter ID="Threshold" ParameterType="double" Selector="$Config/Threshold$"/>

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

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

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

  </OverrideableParameters>

  <MonitorImplementation>

    <MemberModules>

      <DataSource ID="DS" TypeID="Microsoft.SQLServer.2016.ReportingServices.DataSource.Memory">

        <PrincipalName>$Target/Host/Property[Type='Windows!Microsoft.Windows.Computer']/PrincipalName$</PrincipalName>

        <PerformanceCounterObject>$Target/Property[Type='SQLRS!Microsoft.SQLServer.2016.ReportingServices.Instance']/PerformanceCounterObject$</PerformanceCounterObject>

        <InstallPath>$Target/Property[Type='SQLRS!Microsoft.SQLServer.2016.ReportingServices.Instance']/InstallPath$</InstallPath>

        <ServiceName>$Target/Property[Type='SQLRS!Microsoft.SQLServer.2016.ReportingServices.Instance']/ServiceName$</ServiceName>

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

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

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

      </DataSource>

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

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery Type="String">Property[@Name='SQLServerInstalled']</XPathQuery>

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

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

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </ConditionDetection>

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

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery Type="Double">Property[@Name='WorkingSetMaximumPercent']</XPathQuery>

            </ValueExpression>

            <Operator>Greater</Operator>

            <ValueExpression>

              <Value Type="Double">$Config/Threshold$</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </ConditionDetection>

      <!--if ((sql && Value<=$Config/Threshold$) || !sql)-->

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

        <Expression>

          <Or>

            <Expression>

              <And>

                <Expression>

                  <SimpleExpression>

                    <ValueExpression>

                      <XPathQuery Type="String">Property[@Name='SQLServerInstalled']</XPathQuery>

                    </ValueExpression>

                    <Operator>Equal</Operator>

                    <ValueExpression>

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

                    </ValueExpression>

                  </SimpleExpression>

                </Expression>

                <Expression>

                  <SimpleExpression>

                    <ValueExpression>

                      <XPathQuery Type="Double">Property[@Name='WorkingSetMaximumPercent']</XPathQuery>

                    </ValueExpression>

                    <Operator>LessEqual</Operator>

                    <ValueExpression>

                      <Value Type="Double">$Config/Threshold$</Value>

                    </ValueExpression>

                  </SimpleExpression>

                </Expression>

              </And>

            </Expression>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery Type="String">Property[@Name='SQLServerInstalled']</XPathQuery>

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

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

                </ValueExpression>

              </SimpleExpression>

            </Expression>

          </Or>

        </Expression>

      </ConditionDetection>

    </MemberModules>

    <RegularDetections>

      <RegularDetection MonitorTypeStateID="ConfigurationConflict">

        <Node ID="CDConfigurationConflict">

          <Node ID="CDSQLServerInstalled">

            <Node ID="DS"/>

          </Node>

        </Node>

      </RegularDetection>

      <RegularDetection MonitorTypeStateID="NoConfigurationConflict">

        <Node ID="CDNoConfigurationConflict">

          <Node ID="DS"/>

        </Node>

      </RegularDetection>

    </RegularDetections>

  </MonitorImplementation>

</UnitMonitorType>