[SDP 3][eb8c2d7b-f32c-441c-a631-43e67f71f653] Microsoft Dynamics AX Troubleshooter for Windows 7 and Windows Server 2008 R2

Article translations Article translations
Article ID: 2181934 - View products that this article applies to.
Expand all | Collapse all

On This Page

SUMMARY

The Microsoft Dynamics AX Troubleshooter for Windows 7 and Windows Server 2008 R2 collects information that is used to troubleshoot Microsoft Dynamics AX common issues.

MORE INFORMATION

This article describes the information that is collected from a computer when the Microsoft Dynamics AX Troubleshooter for Windows 7 and Windows Server 2008 R2 is run.

Information that is collected


Event logs for the client computer and the Application Object Server computer

Collapse this tableExpand this table
Description
File Name
Event log – Application - All Microsoft Dynamics-related events
ComputerName_evt_Dynamics_application.txt
Event log – Application – Split by event ID
ComputerName_evt_ID_*_application.txt
Event log – Application – All events for last three days
ComputerName_evt_application.csv
Event log – System – All events for last 3 days
ComputerName_evt_system.csv

AOS config file

Collapse this tableExpand this table
Description
File Name
Application Object Server configuration information
ComputerName_AX32SERV.EXE_CONFIG.txt

Client config file

Collapse this tableExpand this table
Description
File Name
Client configuration information
ComputerName_AX32.EXE_CONFIG.txt

Hotfix information

Collapse this tableExpand this table
Description
File Name
Application hotfixes that are installed on the system
ComputerName_SysHotfixManifestVersionInfo.xml

AOS operating system (OS) information
Collapse this tableExpand this table
Description
File Name
OS information for AOS from Windows Management Instrumentation (WMI)
ComputerName_OSINFO.txt

SQL blocking history

Collapse this tableExpand this table
Description
File Name
SQL blocking history from Microsoft SQL Server
ComputerName_SqlBlocking.txt

SQL Error logs

Collapse this tableExpand this table
Description
File Name
Last six Error logs from SQL Server
ComputerName_ERRORLOG*.txt
ComputerName_ERRORLOG*.html
ComputerName_ERRORLOG*.csv
ComputerName_ERRORLOG*.sql

SQL Index usage history

Collapse this tableExpand this table
Description
File Name
Index usage on the SQL Server
ComputerName_SqlIndexUsage.txt

SQL query BATCHSERVERCONFIG

Collapse this tableExpand this table
Description
File Name
Table – BATCHSERVERCONFIG

Note This section will only be collected on Microsoft Dynamics AX 2009.
ComputerName_BATCHSERVERCONFIG.txt
ComputerName_BATCHSERVERCONFIG.html
ComputerName_BATCHSERVERCONFIG.csv

SQL query SYSCLUSTERCONFIG

Collapse this tableExpand this table
Description
File Name
Table – SYSCLUSTERCONFIG
Note This section will only be collected on Microsoft Dynamics AX 2009.
ComputerName_ SYSCLUSTERCONFIG.txt
ComputerName_ SYSCLUSTERCONFIG.html
ComputerName_ SYSCLUSTERCONFIG.csv

SQL query SYSSERVERSESSIONS

Collapse this tableExpand this table
Description
File Name
Table – SYSSERVERSESSIONS
Note This section will only be collected on Microsoft Dynamics AX 2009.
ComputerName_ SYSSERVERSESSIONS.txt
ComputerName_ SYSSERVERSESSIONS.html
ComputerName_ SYSSERVERSESSIONS.csv

SQL queries - Top 25 queries that are performed

Collapse this tableExpand this table
Description
File Name
Top 25 SQL queries that are performed on SQL Server
ComputerName_TOP25Queries.txt
ComputerName_TOP25Queries.html
ComputerName_TOP25Queries.csv
ComputerName_TOP25Queries.sql

SQL Query plans - Top 25 queries

Collapse this tableExpand this table
Description
File Name
Collection of Query Plans for the top 25 queries
ComputerName_QueryPlan_*.sqlplan

SQL Server version

Collapse this tableExpand this table
Description
File Name
SQL Server version information
ComputerName_@@version.txt

Binary version information

Collapse this tableExpand this table
Description
File Name
Versions of EXE and DLL files and other file version information. Information is collected from both client and AOS server computers. The path column in the file will indicate from which computers the version information was collected.
ComputerName_VersionInfo.txt

Additional information

In addition to the files that are collected and listed in the "Information that is collected" section, this troubleshooter can detect one or more of the following situations:
  • Client (AX32.exe) and server (AX32Serv.exe) file version mismatches.
  • Microsoft Dynamics AX hotfixes that are applied if Microsoft Dynamics AX 2009 is running, and the SysHotfixManifest Class is present on the system.
  • Microsoft Dynamics AX Layer and Version information if Microsoft Dynamics AX 2009 is running, and the SysHotfixManifest Class is present on the system.
  • We recommend that you run the diagnostic from a computer that has the Microsoft.Dynamics.BusinessConnectorNet.dll installed.
  • Currently, the troubleshooter reads configuration values from the current configuration within the Microsoft Dynamics AX Configuration Utility and the Microsoft Dynamics AX Server Configuration Utility to correctly determine the AOS instance and SQL Server Instances. However, the troubleshooter does not work with .AXC files (Dynamics Configuration Files).

REFERENCES

973559 Frequently asked questions about the Microsoft Support Diagnostic Tool (MSDT) for Windows 7 and Windows Server R2 (SDP 3.0)

Properties

Article ID: 2181934 - Last Review: December 13, 2011 - Revision: 6.0
APPLIES TO
  • Microsoft Dynamics AX 2012
  • Microsoft Dynamics AX 2009
  • Microsoft Dynamics AX 2009 Service Pack 1
Keywords: 
kbmbsmigrate kbsurveynew KB2181934

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com