Home
  •  

Microsoft Dynamics NAV\# Result set cache total requests

Microsoft.Dynamics.Nav.2015.ResultSetCacheTotalRequests (Rule)

This counter measures the total number of requests to the result set cache. The result set cache contains result sets that are returned from SQL Server.

Knowledge Base article:

Summary

This counter measures the total number of requests to the result set cache. The result set cache contains result sets that are returned from SQL Server.

Element properties:

TargetMicrosoft.Dynamics.Nav.2015.ServerInstance
CategoryPerformanceCollection
EnabledTrue
Instance NameMicrosoft Dynamics NAV
Counter Name# Result set cache total requests
Frequency300
Alert GenerateFalse
RemotableTrue

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource System.Performance.OptimizedDataProvider Microsoft.Dynamics.Nav.2015.DefaultAccount
CollectToDB WriteAction Microsoft.SystemCenter.CollectPerformanceData Default
CollectToDW WriteAction Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData Default

Source Code:

<Rule ID="Microsoft.Dynamics.Nav.2015.ResultSetCacheTotalRequests" Target="Microsoft.Dynamics.Nav.2015.ServerInstance" Enabled="true" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">

  <Category>PerformanceCollection</Category>

  <DataSources>

    <DataSource ID="DS" TypeID="Performance!System.Performance.OptimizedDataProvider" RunAs="Microsoft.Dynamics.Nav.2015.DefaultAccount">

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

      <CounterName># Result set cache total requests</CounterName>

      <ObjectName>Microsoft Dynamics NAV</ObjectName>

      <InstanceName>$Target/Property[Type="Microsoft.Dynamics.Nav.2015.ServerInstance"]/ServerInstance$</InstanceName>

      <AllInstances>false</AllInstances>

      <Frequency>300</Frequency>

      <Tolerance>0</Tolerance>

      <ToleranceType>Absolute</ToleranceType>

      <MaximumSampleSeparation>1</MaximumSampleSeparation>

    </DataSource>

  </DataSources>

  <WriteActions>

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

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

  </WriteActions>

</Rule>