Process (Sql Server) Working Set

Microsoft.Office.Sharepoint.Server.2007.Process_Sql_Server_Working_Set (Rule)

This rule uses the Working Set counter to determine the current size in bytes of the Working Set of this process. The Working Set is the set of memory pages recently touched by the threads in the process. If free memory in the computer is above the rule’s threshold, pages are left in the Working Set of a process even if they are not in use. When free memory falls below the threshold, pages are trimmed from the Working Set. If the pages are needed, they will be soft-faulted back into the Working Set before leaving main memory.

Knowledge Base article:

Element properties:

Member Modules:

Source Code:

<Rule ID="Microsoft.Office.Sharepoint.Server.2007.Process_Sql_Server_Working_Set" Enabled="onEssentialMonitoring" Target="Microsoft.Office.Sharepoint.Server.2007.MOSS.Server" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">

  <Category>PerformanceCollection</Category>

  <DataSources>

    <DataSource ID="DS" TypeID="Performance!System.Performance.OptimizedDataProvider">

      <ComputerName>$Target/Host/Property[Type="MSWL!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

      <CounterName>Working Set</CounterName>

      <ObjectName>Process</ObjectName>

      <InstanceName>sqlservr</InstanceName>

      <AllInstances>false</AllInstances>

      <Frequency>3600</Frequency>

      <Tolerance>10</Tolerance>

      <ToleranceType>Percentage</ToleranceType>

      <MaximumSampleSeparation>2</MaximumSampleSeparation>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="CollectData" TypeID="SystemCenter!Microsoft.SystemCenter.CollectPerformanceData"/>

    <WriteAction ID="DataWarehousePublishData" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>

  </WriteActions>

</Rule>