Home
  •  

Database auto create statistics

Microsoft.Dynamics.AX6.ManagementPack.AOS.Monitoring.Database.AutoCreateStatisticsMonitor (UnitMonitor)

Determines whether the Auto Create Statistics property is set to True for the Microsoft Dynamics AX database.

Knowledge Base article:

Summary

The Auto Create Statistics property must be set to True for the Microsoft Dynamics AX database.

Causes

The Auto Create Statistics property is set to False for the Microsoft Dynamics AX database.

Resolutions

Open SQL Server Management Studio and set the Auto Create Statistics property to True. For more information, see the SQL Server documentation.

External

For more information about configuring SQL Server, see the following resources:

Element properties:

TargetMicrosoft.Dynamics.AX6.ManagementPack.ClassLibrary.AxDatabase
Parent MonitorSystem.Health.ConfigurationState
CategoryCustom
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveTrue
Monitor TypeMicrosoft.Dynamics.AX6.ManagementPack.AOS.Monitoring.Database.AutoCreateStatistics
RemotableTrue
AccessibilityPublic
RunAsMicrosoft.Dynamics.AX6.ManagementPack.ClassLibrary.AxDbReaderAccount

Source Code:

<UnitMonitor ID="Microsoft.Dynamics.AX6.ManagementPack.AOS.Monitoring.Database.AutoCreateStatisticsMonitor" Accessibility="Public" Enabled="true" Target="MicrosoftDynamicsAX6ManagementPackClassLibrary!Microsoft.Dynamics.AX6.ManagementPack.ClassLibrary.AxDatabase" ParentMonitorID="Health!System.Health.ConfigurationState" Remotable="true" Priority="Normal" RunAs="MicrosoftDynamicsAX6ManagementPackClassLibrary!Microsoft.Dynamics.AX6.ManagementPack.ClassLibrary.AxDbReaderAccount" TypeID="Microsoft.Dynamics.AX6.ManagementPack.AOS.Monitoring.Database.AutoCreateStatistics" ConfirmDelivery="true">

  <Category>Custom</Category>

  <OperationalStates>

    <OperationalState ID="UIGeneratedOpStateId5bff5876afc049ac875895aef387a7c8" MonitorTypeStateID="EqualToTrue" HealthState="Success"/>

    <OperationalState ID="UIGeneratedOpStateIda318408d7ecf4be891df3c6c35b18138" MonitorTypeStateID="NotEqualToTrue" HealthState="Warning"/>

  </OperationalStates>

  <Configuration>

    <IntervalSeconds>1200</IntervalSeconds>

  </Configuration>

</UnitMonitor>