Home
  •  

TotalMemoryLimit Configuration monitor type

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

TotalMemoryLimit Configuration monitor type for 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$Warning Threshold (GB)The monitor alerts when the configured TotalMemoryLimit for the SSAS instance exceeds the configured threshold, risking allocation of physical memory required for the operating system to perform necessary basic functions, at least 2 GB.
IntervalSecondsint$Config/IntervalSeconds$Interval SecondsThe recurring interval of time in seconds in which to run the workflow.
SyncTimestring$Config/SyncTime$Synchronization TimeThe synchronization time specified by using a 24-hour format. May be omitted.

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>