Home
  •  

Tipo de monitor de configuración de TotalMemoryLimit

Microsoft.SQLServer.2014.AnalysisServices.MonitorType.Instance.TotalMemoryConfiguration (UnitMonitorType)

Tipo de monitor de configuración de TotalMemoryLimit para Analysis Services

Element properties:

RunAsMicrosoft.SQLServer.2014.AnalysisServices.RunAsProfile.ASMonitoring
AccessibilityInternal
Support Monitor RecalculateFalse

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.SQLServer.2014.AnalysisServices.DataSource.MemoryUsage Default
CDConfigured ConditionDetection System.ExpressionFilter Default
CDNotConfigured ConditionDetection System.ExpressionFilter Default

Overrideable Parameters:

IDParameterTypeSelectorDisplay NameDescription
Thresholddouble$Config/Threshold$Umbral de advertencia (GB)El monitor genera una alerta cuando el valor de TotalMemoryLimit configurado para la instancia de SSAS supera el umbral configurado, lo que pone en riesgo la asignación de la memoria física necesaria para que el sistema operativo realice las funciones básicas necesarias (al menos 2 GB).
IntervalSecondsint$Config/IntervalSeconds$Intervalo (segundos)Intervalo de tiempo periódico en segundos en que se ejecuta el flujo de trabajo.
SyncTimestring$Config/SyncTime$Hora de sincronizaciónHora de sincronización especificada en un formato de 24 horas. Se puede omitir.

Source Code:

<UnitMonitorType ID="Microsoft.SQLServer.2014.AnalysisServices.MonitorType.Instance.TotalMemoryConfiguration" Accessibility="Internal" RunAs="SQLAS!Microsoft.SQLServer.2014.AnalysisServices.RunAsProfile.ASMonitoring">

  <MonitorTypeStates>

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

    <MonitorTypeState ID="Configured" 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"/>

  </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$"/>

  </OverrideableParameters>

  <MonitorImplementation>

    <MemberModules>

      <DataSource ID="DS" TypeID="Microsoft.SQLServer.2014.AnalysisServices.DataSource.MemoryUsage">

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

        <PerformanceCounterObject>$Target/Property[Type='SQLAS!Microsoft.SQLServer.2014.AnalysisServices.Instance']/PerformanceCounterObject$</PerformanceCounterObject>

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

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

        <ConnectionString>$Target/Property[Type='SQLAS!Microsoft.SQLServer.2014.AnalysisServices.Instance']/ConnectionString$</ConnectionString>

      </DataSource>

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

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Less</Operator>

            <ValueExpression>

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

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </ConditionDetection>

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

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>GreaterEqual</Operator>

            <ValueExpression>

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

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </ConditionDetection>

    </MemberModules>

    <RegularDetections>

      <RegularDetection MonitorTypeStateID="Configured">

        <Node ID="CDConfigured">

          <Node ID="DS"/>

        </Node>

      </RegularDetection>

      <RegularDetection MonitorTypeStateID="NotConfigured">

        <Node ID="CDNotConfigured">

          <Node ID="DS"/>

        </Node>

      </RegularDetection>

    </RegularDetections>

  </MonitorImplementation>

</UnitMonitorType>