Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. [SDP 3][eb8c2d7b-f32c-441c-a631-43e67f71f653] Microsoft Dynamics AX Baseline Diagnostic

[SDP 3][eb8c2d7b-f32c-441c-a631-43e67f71f653] Microsoft Dynamics AX Baseline Diagnostic

View products that this article applies to.

Summary

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

↑ Back to the top

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})
{ComputerName}_AXClientConfig.TXT

AX DataBase Logging Enabled for Tables
DescriptionFile name
The file lists all tables that have DB logging enabled.
{ComputerName}_DataBaseLoggingEnabled.txt

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:
BuildNumber
Description
Layer
Model DisplayName
Model Name
Publisher
{ComputerName}_AX2012ModelMetaDataAndHotfixInfo.htm
{ComputerName}_AX2012ModelMetaDataAndHotfixInfo.xml

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.
{ComputerName}_ModelsInstalled.txt

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
{ComputerName}_AX_AOS_Service_Info.html

AX Tables configuration
DescriptionFile 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
DescriptionFile 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
DescriptionFile name
Contains information pertaining to the last CIL compilation
Dynamics.Ax.Application.dll.log

Dynamics AX Installed Componenets
DescriptionFile name
These are the currently installed programs for Dynamics AX.
{ComputerName}_AX_Installed_Components.htm

General Information
DescriptionFile name
Show if machine is running on a Virtual Environment and describes the virtualization environment
 resultreport.xml


Memory Dump Information and Files
DescriptionFile 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
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
{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
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
{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
  • Detect if this machine is a Virtual Machine running in Microsoft Azure
  • 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 Information about Microsoft Automated Troubleshooting Services and Support Diagnostic Platform

↑ Back to the top

Keywords: kbmbspartner, kbmbsmigrate, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2181934
Revision : 1
Created on : 1/7/2017
Published on : 2/3/2017
Exists online : False
Views : 467