[SDP 3][D12F29E7-18CE-4326-A893-E2BDFE6A607F] Microsoft Dynamics AX AOS Diagnostic


This diagnostic tool collects Dynamics AX Application Object Server(AOS) information.

More Information

Typically this diagnostic should be ran from a machine where the AX Client is installed and is pointing to a working AOS instance.

Information Collected

AX Client Config Registry keys
DescriptionFile name
Registry entries for the Current AX Client configuration (HKCU\Software\Microsoft\Dynamics\{Version}\{Current Configuration})

AX DataBase Logging Enabled for Tables
DescriptionFile name
The file lists all tables that have DB logging enabled.

AX Model Layer and Hotfix Information
DescriptionFile name
A report that includes Layer and Model information, below are the fields included for each Model and hotfix:
Model DisplayName
Model Name

AX Models Installed
DescriptionFile name
This is a quick text veiw of the ID, Layer, Model, Version and Publisher from running the command axutil.exe list.

AX Service Information - AOS
DescriptionFile name
AOS service information in an html report - AOS Service Logon Account, AOS Service Start, AOS Service Type, AOS Service DisplayName

AX Tables configuration
DescriptionFile name
select * from BATCHSERVERCONFIG (nolock)
select * from SYSCLUSTERCONFIG (nolock)
select * from SYSSERVERCONFIG(nolock)

AX Version and Config information
DescriptionFile name
AOS Instance Name
AOS IP Address
AOS Ping ResponseTime
AOS Server Name
Application Version
Configuration Used
Connected to SQL Server
Installed Layers
Is Machine a TerminalServer
Is Machine an AOS
Kernel Version
Logged in as
Serial number
USER Domain
USER Profile
USER Temp Dir

Dynamics AX CIL Generation log
DescriptionFile name
Contains information pertaining to the last CIL compilation

Dynamics AX Installed Componenets
DescriptionFile name
These are the currently installed programs for Dynamics AX.

Memory Dump Information and Files
DescriptionFile name
Information about machine memory dump files, user memory dump files, and memory dump configuration
Machine Full or Kernel memory dump files (Memory.dmp)
Mini memory dump files from {Windows}\Minidump folder
User dumps generated by Windows Error Reporting

SQL Performance
DescriptionFile name
select db_name(database_id) DB, object_name(object_id) Obj, row_lock_count + page_lock_count No_Of_Locks, row_lock_wait_count + page_lock_wait_count No_Of_Blocks, row_lock_wait_in_ms + page_lock_wait_in_ms Block_Wait_Time, index_id from sys.dm_db_index_operational_stats(NULL,NULL,NULL,NULL) order by Block_Wait_Time desc
select SELECT TOP 25 total_elapsed_time, execution_count, (total_elapsed_time/execution_count)/1000.0 AS [avg_elapsed_time_ms], total_logical_reads/execution_count AS [avg_logical_reads], SUBSTRING(st.text, (qs.statement_start_offset/2)+1, ((CASE qs.statement_end_offset WHEN -1 THEN DATALENGTH(st.text) ELSE qs.statement_end_offset END - qs.statement_start_offset)/2) + 1) AS sql_text, qp.query_plan FROM sys.dm_exec_query_stats AS qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) as qp --where st.text like '%search criteria here%' ORDER BY total_elapsed_time DESC
{ComputerName}_SQL Top 25 Queries
select * from sys.configurations(nolock)
select name as DBName, is_read_committed_snapshot_on, snapshot_isolation_state, is_auto_create_stats_on, is_auto_update_stats_on, is_auto_shrink_on, recovery_model, compatibility_level, is_auto_close_on, is_auto_shrink_on from sys.databases where name = @DBName
select TOP(1000)* from SYSEXCEPTIONTABLE (nolock) order by Createddatetime desc

SQL Server Agent logs
DescriptionFile name
Collects SQL Server Agent logs for all instances that are installed on the computer on which the diagnostic tool is executed, where {INSTANCE_NAME} is the name of the instance or MSSQLSERVER for default instance
{ComputerName}_{INSTANCE_NAME}_1033_SQLAGENT.[OUT | n]

SQL Server error logs
DescriptionFile name
Collects SQL Server error logs for all instances that are installed on the computer on which the diagnostic tool is executed, where {INSTANCE_NAME} is the name of the instance or MSSQLSERVER for default instance

In addition to collecting the information that is described earlier, this diagnostic package can detect one or more of the following symptoms:

  • Microsoft Dynamics AX Protocol error in RPC exception 1726
  • Generate ORDER BY clauses from WHERE Clauses
  • Maximum Open Cursors
  • Maximum Open Cursors for AX 2012 RTM and FP1
  • Maximum Open Cursors for AX 2012 R2
  • Maximum Buffer Size
  • Maximum Buffer Size AX 2012 R2
  • Use literals in complex joins from X++
  • Use literals in join queries from forms and reports
  • X++ debugging is enabled.
  • Usetemptable registry value detected.
  • Dynamics AX 2012 hot-swapping enabled on AOS.
  • Global Break Points are enabled.
  • Event Logs Messages
  • Memory Dump Related Issues
  • Dynamics AX 2012 RTM version detected without Rollups
  • Dynamics AX 2009 RTM version detected without Rollups
  • Dynamics AX 2009 SP1 version detected without Rollups
  • Compatibility of Microsoft SQL Server 2012 with Microsoft Dynamics AX 2012
  • Can't find or connect to a valid AOS instance
  • The SQL Server Max Degree of Parallelism option is set to on.
  • READ_COMMITTED_SNAPSHOT ON is required for normal AOS operation with SQL server
  • The SQL Server Auto-Create Stats option is set to Off.
  • The SQL Server Auto-Update Stats option is set to Off.
  • The SQL Server Auto Shrink option is set to on.
  • Verify SQL Server 2008 R2, typically SQL Server 2008 R2 SP1 should be installed.
  • Global SQL Trace Flags are enabled and could affect SQL’s performance
  • Check for presence of dpfbview.dll (HP ProtectTools) is installed on the computer.
  • Database Logging Enabled
  • CIL Generation Log not found
  • Client WSDL Port number differs from AOS WSDL Port number
  • Dynamics AX Client and AOS Version mismatch


For more information about the Microsoft Automated Troubleshooting Services and about the Support Diagnostics Platform, please open the following Microsoft Knowledge Base article:

2598970 Information about Microsoft Automated Troubleshooting Services and Support Diagnostic Platform


رقم الموضوع: 2416076 - آخر مراجعة: 18‏/04‏/2013 - المراجعة: 1

Microsoft Dynamics AX 2012, Microsoft Dynamics AX 2009, Microsoft Dynamics AX 4.0