This diagnostic tool collects Dynamics AX Application Object Server(AOS) 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
Collapse this tableExpand this table
| Description | File name |
Registry entries for the Current AX Client configuration (HKCU\Software\Microsoft\Dynamics\{Version}\{Current Configuration})
| {ComputerName}_AXClientConfig.TXT
|
AX DataBase Logging Enabled for Tables
Collapse this tableExpand this table
| Description | File name |
The file lists all tables that have DB logging enabled.
| {ComputerName}_DataBaseLoggingEnabled.txt
|
AX Model Layer and Hotfix Information
Collapse this tableExpand this table
| Description | File name |
A report that includes Layer and Model information, below are the fields included for each Model and hotfix:
BuildNumber
Description
Layer
Model DisplayName
Model Name
Publisher
| {ComputerName}_AX2012ModelMetaDataAndHotfixInfo.htm
{ComputerName}_AX2012ModelMetaDataAndHotfixInfo.xml
|
AX Models Installed
Collapse this tableExpand this table
| Description | File name |
This is a quick text veiw of the ID, Layer, Model, Version and Publisher from running the command axutil.exe list.
| {ComputerName}_ModelsInstalled.txt
|
AX Service Information - AOS
Collapse this tableExpand this table
| Description | File name |
AOS service information in an html report - AOS Service Logon Account, AOS Service Start, AOS Service Type, AOS Service DisplayName
| {ComputerName}_AX_AOS_Service_Info.html
|
AX Tables configuration
Collapse this tableExpand this table
| Description | File name |
select * from BATCHSERVERCONFIG (nolock)
| {ComputerName}_AX_BATCHSERVERCONFIG
|
select * from SYSCLUSTERCONFIG (nolock)
| {ComputerName}_AX_SYSCLUSTERCONFIG
|
select * from SYSSERVERCONFIG(nolock)
| {ComputerName}_AX_SYSSERVERCONFIG
|
AX Version and Config information
Collapse this tableExpand this table
| Description | File name |
AOS Instance Name
AOS IP Address
AOS Ping ResponseTime
AOS Server Name
Application Version
AXClientConfigName
Company
Configuration Used
Connected to SQL Server
Installed Layers
Is Machine a TerminalServer
Is Machine an AOS
Kernel Version
Language
Logged in as
RegisteredCompanyName
Serial number
TCP/IP Port
USER DNS Domain
USER Domain
USER Profile
USER Temp Dir
| ResultReport.xml
|
Dynamics AX CIL Generation log
Collapse this tableExpand this table
| Description | File name |
Contains information pertaining to the last CIL compilation
| Dynamics.Ax.Application.dll.log
|
Dynamics AX Installed Componenets
Collapse this tableExpand this table
| Description | File name |
These are the currently installed programs for Dynamics AX.
| {ComputerName}_AX_Installed_Components.htm
|
Memory Dump Information and Files
Collapse this tableExpand this table
| Description | File name |
Information about machine memory dump files, user memory dump files, and memory dump configuration
| {ComputerName}_DumpReport.*
|
Machine Full or Kernel memory dump files (Memory.dmp)
| {ComputerName}_dmp_memory.zip
|
Mini memory dump files from {Windows}\Minidump folder
User dumps generated by Windows Error Reporting
| {ComputerName}_dmp_*.zip
|
SQL Performance
Collapse this tableExpand this table
| Description | File 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
| {ComputerName}_AX_SQLBlocking
|
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)
| {ComputerName}_sys.databases.csv
|
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
| {ComputerName}_Sys.Configurations.csv
|
select TOP(1000)* from SYSEXCEPTIONTABLE (nolock) order by Createddatetime desc
| {ComputerName}_AX_SYSEXCEPTIONTABLE
|
SQL Server Agent logs
Collapse this tableExpand this table
| Description | File 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
Collapse this tableExpand this table
| Description | File 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
| {ComputerName}_{INSTANCE_NAME}_1033_ERRORLOG[.n]
|
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
References
For more information about the Microsoft Automated Troubleshooting Services and about the Support Diagnostics Platform, please open the following Microsoft Knowledge Base article:
2598970
(http://support.microsoft.com/kb/2598970/
)
Information about Microsoft Automated Troubleshooting Services and Support Diagnostic Platform
Article ID: 2416076 - Last Review: April 18, 2013 - Revision: 7.0
Applies to
- Microsoft Dynamics AX 2012
- Microsoft Dynamics AX 2009
- Microsoft Dynamics AX 4.0
| kbmbsmigrate kbsurveynew KB2416076 |
Back to the top
