Home
  •  

Database isolation level

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

Determines whether the isolation level for the Microsoft Dynamics AX database is set to READ_COMMITTED_SNAPSHOT.

Knowledge Base article:

Summary

The isolation level for the Microsoft Dynamics AX database should be set to READ_COMMITTED_SNAPSHOT.

Causes

The isolation level for the Microsoft Dynamics AX database is not set to READ_COMMITTED_SNAPSHOT.

Resolutions

See the SQL Server documentation for instructions about how to set the isolation level for the Microsoft Dynamics AX database to READ_COMMITTED_SNAPSHOT.

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.ReadCommittedSnapshotIsolation
RemotableTrue
AccessibilityPublic
RunAsMicrosoft.Dynamics.AX6.ManagementPack.ClassLibrary.AxDbReaderAccount

Source Code:

<UnitMonitor ID="Microsoft.Dynamics.AX6.ManagementPack.AOS.Monitoring.Database.ReadCommittedSnapshotIsolationMonitor" 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.ReadCommittedSnapshotIsolation" ConfirmDelivery="true">

  <Category>Custom</Category>

  <OperationalStates>

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

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

  </OperationalStates>

  <Configuration>

    <IntervalSeconds>1200</IntervalSeconds>

  </Configuration>

</UnitMonitor>