Home
  •  

Microsoft Dynamics NAV\\% Primary key cache hit rate

Microsoft.Dynamics.Nav.2013.PrimaryKeyCacheHit (Rule)

This counter measures the percentage of hits in the primary key cache, compared to the total requests to the primary key cache.

Knowledge Base article:

Summary

This counter measures the percentage of hits in the primary key cache, compared to the total requests to the primary key cache.

Element properties:

TargetMicrosoft.Dynamics.Nav.2013.ServerInstance
CategoryPerformanceCollection
EnabledTrue
Instance NameMicrosoft Dynamics NAV
Counter Name\% Primary key cache hit rate
Frequency300
Alert GenerateFalse
RemotableTrue

Member Modules:

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

Source Code:

<Rule ID="Microsoft.Dynamics.Nav.2013.PrimaryKeyCacheHit" Target="Microsoft.Dynamics.Nav.2013.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.2013.DefaultAccount">

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

      <CounterName>% Primary key cache hit rate</CounterName>

      <ObjectName>Microsoft Dynamics NAV</ObjectName>

      <InstanceName>$Target/Property[Type="Microsoft.Dynamics.Nav.2013.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>