GlenTurnbull articles

GlenTurnbull
Published 
2 min read

Collect Dynamics 365 for Finance and Operations event traces with Windows Performance Monitor 

Just as with AX 2012, users can collect Dynamics 365 for Finance and Operations event traces using Windows Performance Monitor. Other options are explained here: https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/perf-test/trace-trace-tutorial (web version) https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/perf-test/trace-parser (desktop version) Windows Performance Monitor can be used in non-production where the Dynamics 365 for Finance and Operations client tracing is not possible. For example, WMS
Published 
2 min read

Optional Additional Installation Script for Blocking Analysis with DynamicsPerf v2.0 

In relation to the analysis scripts that come with DynamicsPerf (Performance Analyzer) v2.0, (based on the new extended events being used in place of the SQL profiler trace which featured in v1.20), i.e.: … —            BLOCKING_EVENTS — Blocking events sorted by TIME desc —————————————————————- SELECT TOP 100 * FROM (SELECT event_data.value(‘(event/@name)[1]’, ‘varchar(50)’) AS EVENT_NAME, DATEADD(hh, DATEDIFF(hh,
Published 
3 min read

Check AOS event logs and SQL Server error logs for key messages using DynamicsPerf 

As part of general monitoring of Dynamics AX overall system health and/or troubleshooting, you’ll want to check the Windows event logs in your AOS server(s) and SQL Server error logs. If you have DynamicsPerf (Performance Analyzer for Microsoft Dynamics) installed, you can quickly check for key messages and if necessary, export and move them all
Published 
7 min read

Analysis scripts for Performance Analyzer v2.0 

Following on from my previous blog post regarding analysis scripts for the tool Performance Analyzer v1.20*, I am now publishing the scripts that come with the latest version, 2.0. (*Previous post: https://blogs.msdn.microsoft.com/axsupport/2014/08/31/microsoft-dynamics-ax-general-performance-analysis-scripts/) Download link: https://dynamicsperf.codeplex.com/ After downloading and extracting the tool from the above link, you can find these scripts in the following sub-folders: ..\DynamicsPerf\DynamicsPerf
Published 
3 min read

Analysis scripts for Performance Analyzer v2.0 Page 10 

This is page 10 of 10 of the general performance analysis scripts online for the Performance Analyzer 2.0 tool. See page 1 for the introduction. Use the links in the table below to navigate between pages. – General analysis Analyse SQL Configuration Page 1 Analyse SQL Indexes Page 2 Analyse SQL Queries Page 3 Analyse Blocking
Published 
12 min read

Analysis scripts for Performance Analyzer v2.0 Page 2 

This is page 2 of 10 of the general performance analysis scripts online for the Performance Analyzer 2.0 tool. See page 1 for the introduction. Use the links in the table below to navigate between pages. – General analysis Analyse SQL Configuration Page 1 Analyse SQL Indexes Page 2 Analyse SQL Queries Page 3 Analyse Blocking
Published 
7 min read

Analysis scripts for Performance Analyzer v2.0 Page 3 

This is page 3 of 10 of the general performance analysis scripts online for the Performance Analyzer 2.0 tool. See page 1 for the introduction. Use the links in the table below to navigate between pages. – General analysis Analyse SQL Configuration Page 1 Analyse SQL Indexes Page 2 Analyse SQL Queries Page 3 Analyse Blocking
Published 
8 min read

Analysis scripts for Performance Analyzer v2.0 Page 4 

This is page 4 of 10 of the general performance analysis scripts online for the Performance Analyzer 2.0 tool. See page 1 for the introduction. Use the links in the table below to navigate between pages. – General analysis Analyse SQL Configuration Page 1 Analyse SQL Indexes Page 2 Analyse SQL Queries Page 3 Analyse Blocking
Published 
9 min read

Analysis scripts for Performance Analyzer v2.0 Page 5 

This is page 5 of 10 of the general performance analysis scripts online for the Performance Analyzer 2.0 tool. See page 1 for the introduction. Use the links in the table below to navigate between pages. – General analysis Analyse SQL Configuration Page 1 Analyse SQL Indexes Page 2 Analyse SQL Queries Page 3 Analyse Blocking
Published 
3 min read

Analysis scripts for Performance Analyzer v2.0 Page 6 

This is page 6 of 10 of the general performance analysis scripts online for the Performance Analyzer 2.0 tool. See page 1 for the introduction. Use the links in the table below to navigate between pages. – General analysis Analyse SQL Configuration Page 1 Analyse SQL Indexes Page 2 Analyse SQL Queries Page 3 Analyse Blocking
Published 
1 min read

Analysis scripts for Performance Analyzer v2.0 Page 7 

This is page 7 of 10 of the general performance analysis scripts online for the Performance Analyzer 2.0 tool. See page 1 for the introduction. Use the links in the table below to navigate between pages. – General analysis Analyse SQL Configuration Page 1 Analyse SQL Indexes Page 2 Analyse SQL Queries Page 3 Analyse Blocking
Published 
11 min read

Analysis scripts for Performance Analyzer v2.0 Page 8 

This is page 8 of 10 of the general performance analysis scripts online for the Performance Analyzer 2.0 tool. See page 1 for the introduction. Use the links in the table below to navigate between pages. – General analysis Analyse SQL Configuration Page 1 Analyse SQL Indexes Page 2 Analyse SQL Queries Page 3 Analyse Blocking