DynamicsPerf 2.10 Installation for Dynamics 365 Local Business Data (On Prem) / Dynamics AX

INTRODUCTION Please be sure to install the core components of Performance Analyzer for Microsoft Dynamics before completing this guide. https://blogs.msdn.microsoft.com/axinthefield/dynamicsperf-2-10-deployment-guide/ The Performance Analyzer is delivered as a SQL Server solution and consists of a number of collectors as SQL jobs, X++ classes, VB scripts and performance counters. It also includes a set of sample SQL…


AX Performance Monitor 101 – Tips and tricks to deal with performance counter files

In my previous blog post, I explained how to setup Performance Monitor (PerfMon) to proactively capture performance data while cleaning old files to keep disk space under control. This is, let’s say, our ideal scenario, but sometimes setup is not that specific and we need to deal with suboptimal files that contains the performance data…


AX Performance Monitor 101 – Setup Perfmon for continuous monitoring with rolling files

  Windows Performance Monitor (PerfMon) is likely the most useful tool (together with our DynamicsPerf package) to monitor and diagnose performance problems related with your Microsoft Dynamics AX infrastructure and, in general, for any software running on Windows operating systems. Given its importance, is surprising how many people is not using it properly or, even worst, is not using…


DynamicsPerf 2.0 Nov. 2017 Patch is Released !!

With the move over to Github: https://github.com/PFEDynamics/DynamicsPerf , we have also posted a new patch for DynamicsPerf 2.0.   Highlights: New SSRS reports – Updated reports based on the INDEX_HISTORY table in DynamicsPerf New and improved sample queries .. .. Improved collection to better limit the SIZE of DynamicsPerf  !!   We have been testing…


New HOME for DynamicsPerf !!!!

With codeplex shutting down, we have moved DynamicsPerf over to Github.   You can find the download at:  https://github.com/PFEDynamics/DynamicsPerf   Rod “Hotrod” Hansen


DynamicsPerf 2.0 Release Candidate 0 is HERE !!

Release Candidate 0 is finally complete.  You can find the download here: DynamicsPerf 2.0. A big THANK YOU to my early testers of RC0!! They were able to help me find a last minute issue which was the cause of the delay between when I posted the What’s New in DynamicsPerf 2.0 Release Candidate 0…

4

What’s New in DynamicsPerf 2.0 Release Candidate 0

First, I want to say “Thank You” to the community.  All of the feedback has been greatly appreciated.   Let’s start with SSRS data collection.   This is now working as designed.  There were some schema changes needed to get this working as necessary so the upgrade script will truncate the SSRS_HISTORY table and the…

11

What’s New in Beta 5

A big THANKS to the community that has been helping test DynamicsPerf 2.0 !! Beta 5 has been posted here: DynamicsPerf 2.0 Beta 5 For anyone who has an older beta installed, it is highly recommended to upgrade to Beta 5.  The biggest issue that has been corrected in Beta 5 is the purge script. …

13

DynamicsPerf 2.0 QUERY ALERTS

In the upcoming Beta 3 of DynamicsPerf 2.0, we have implemented a new feature called QUERY ALERTS.  The inspiration for the design has come from all of you.  One of the big challenges that we all face with performance is that sudden slowdown of the system.  In general, this happens for 2 major reasons, database…

1

DynamicsPerf 2.0 Comparing AX schema

With DynamicsPerf 2.0 , we made schema changes to better support multiple databases and environments.  This change includes AOTEXPORT class that provides table and index schema from Dynamics AX into the DynamicsPerf database. The new AOTEXPORT class now writes data directly to DynamicsPerf.  What this allows you to do that you really couldn’t do before…


DynamicsPerf 2.0 IS HERE !!

I have opened the downloads for DynamicsPerf 2.0 Beta 1 today Jan. 6, 2016.  You can download it from here: DynamicsPerf 2.0 for SQL2008R2 and Above. The deployment guide for installation can be found here: DynamicsPerf 2.0 Deployment Guide.aspx Please post any issues you may find on the ISSUES tab of the download site.  I…

7

Setting up Windows Performance Monitor Templates

To log valuable information about your database server such as disk, processor, memory and network, it is important to configure and schedule the performance counter logging. In the following steps, you will configure the database server for performance counter logging. This information will be logged to performance counter log files. First we can setup the…


DynamicsPerf 2.0 Historical Tables and Baselines

Another one of the new features in version 2.0 is the addition of HISTORICAL TABLES: QUERY_HISTORY INDEX_HISTORY We collect query data every 5 minutes by default and index data every hour on the hour. With this increase in collection of detailed data, it was pretty apparent that the DynamicsPerf database would quickly grow to large.We…


DynamicsPerf 2.0 Scheduling Engine

  One of the new features of DynamicsPerf 2.0 is the way tasks are now run using a scheduling engine inside of DynamicsPerf. There were 2 goals for this new design.  The first being able to deliver customized data collection for different environments.  A good example of this would be for collection at a retail…

6

DynamicsPerf 2.0 Deployment Guide

INTRODUCTION The tool DynamicsPerf (Performance Analyzer for Dynamics) is used by Microsoft Dynamics Support team, Premier Field Engineers and Product Group team members to diagnose performance issues with Dynamics products such as Dynamics AX and Dynamics CRM. IMPORTANT: The purpose of the Performance Analyzer is to be used on a continual basis so it is…

22

DynamicsPerf 2.0 Installation for Dynamics AX

INTRODUCTION Please be sure to install the core components of Performance Analyzer for Microsoft Dynamics before completing this guide. Dynamicsperf-2-0-deployment-guide The Performance Analyzer is delivered as a SQL Server solution and consists of a number of collectors as SQL jobs, X++ classes, VB scripts and performance counters. It also includes a set of sample SQL scripts…

10

Top 10 tips to prepare your Dynamics AX 2012 Go Live – Series 3/3

Hi, This is the third and last part of “the top 10 recommendations” list to prepare a Microsoft Dynamics AX 2012 Go Live. 7. Prepare Windows Performance Monitoring for ETL trace We do not recommend to collect such Dynamics AX trace in production because it can generate a very large size file and eventually impact performance. Also…


Top 10 tips to prepare your Dynamics AX 2012 Go Live – Series 2/3

Hi, Let’s now have a look at the second part of “the top 10 recommendations” list to prepare a Microsoft Dynamics AX 2012 Go Live. 4. Review long running queries from Dynamics AX users This is my favourite tool when it comes to performance monitoring. Other tools will give you great insight for Expensive queries (DynamicsPerf)…


Top 10 tips to prepare your Dynamics AX 2012 Go Live – Series 1/3

When customer is starting a new Dynamics AX 2012 instance, Microsoft Premier Field Engineer are often asked to support them on-site in case something goes wrong. Because of wide nature of incidents, it is always necessary to setup the right tools in production to collect the relevant data and keep the system healthy. We also…


DynamicsPerf Deep Dive Blog Series

  Welcome to my blog series on Performance Analyzer for Microsoft Dynamics (Dynamicsperf) !! In this series of blogs, I will be covering the technical details of the DynamicsPerf toolset and how to analyze the data. Bookmark this blog entry and check back often. I will be linking to all of the blogs in this…


DynamicsPerf Deep Dive – The Vision

  Before I dive into all of the things you can do with DynamicsPerf, I think it’s important that I describe its history as this will tell you a lot about the vision for the toolset. DynamicsPerf was born during the development of SQL Server 2005 which gave us Dynamic Management Views (DMVs).  Mark Prazak…

2

Convergence EMEA, November 2014

Hi all, We are pleased to announce that Premier Field Engineer team is going to be at next EMEA Convergence event. This will take place the 4-5-6 of November in Barcelona. You can now Schedule your private agenda with the Convergence Schedule Builder. Here are two sessions that me and my colleagues Steven Vlaanderen Oldenzeel…


DynamicsPerf 1.20 RTM is HERE !!

  I would like to announce that the RTM build of DynamicsPerf 1.20 has been posted to http://dynamicsperf.codeplex.com.  There is an upgrade script for both 1.20 RC0 and for those running on 1.16.  A big thank you to everyone that gave feedback on this version!! I will be authoring a series of blog articles called…

5

What time is it? Another new feature in Performance Analyzer for Microsoft Dynamics ( DynamicsPerf )

In the next release of Performance Analyzer for Microsoft Dynamics (DynamicsPerf), we will be making a schema change to the AX_SQLTRACE table.  Currently, the [CREATED_DATETIME] column is stored in GMT time.  Dynamics AX stores it this way to adjust for clients being in multiple time zones. So, in our next release, we will be adjusting…


Benchmark your Dynamics AX solution with Load Testing

One of the most crucial time when implementing your Dynamics AX solution is the few weeks prior the Go Live. At that stage, the infrastructure has been configured with all components and all settings have been reviewed to match best practices. The functional team is running all test cases to sign off all design changes…


Top 10 issues discovered from Dynamics AX Health Check

The Premier Field Engineer team has been running several hundred of Dynamics AX Health Check worldwide and I thought it would be interested to share the most common issues discovered during onsite. Some of the following issues might look trivial but the reality is that despite all the literature that exists today on the solution…


Database Maintenance Strategies for Dynamics AX

Database Maintenance Strategies with Microsoft Dynamics AX AX utilizes SQL Indexes in order to speed up queries to the database. It is important that any index created is analyzed for its usage pattern; for example, will the query only be made once per day, or thousands of times in a loop? It might not be…

5

Performance Analyzer Reports

We’re excited to introduce the next evolution with our Performance Analyzer for Microsoft Dynamics toolset.  We’ll review the concepts today at Convergence at the Performance Analyzer for Microsoft Dynamics session at 5pm in the Hilton Ballroom B on the 2nd floor.  In this post, we’ll list the reports that are included in the attached zip…

1

AXUG Roundup – January in Minneapolis

Rod Hansen and I headed south to Minneapolis (yes, everything is south of Fargo) to join the Minnesota chapter of AXUG for dinner and a discussion on the Performance Analyzer tool.  The Minnesota chapter is very well attended and we had a good turnout for this meeting – about 20 folks there in total.  Ben Syltie…

1

Top 5 Cases for Remote Service Delivery

Our Premier Field Engineers travel a lot.  When customers need assistance during deployments or need a workshop or want to make sure their team is up to speed on what we’re delivering, they request us to be onsite and we come on out.  The opportunity to be out working directly at the customer site greatly…


Performance Analyzer for Dynamics – Feedback Requested

We are getting close to the release of the Version 1.10 for the Performance Analyzer for Dynamics, and we thought it would be a great time to start getting feedback for the next version of the tool (Version 1.2).  We have some plans in place already, including adding hooks into AX 2012 to pull more…


SQL Server Lock Escalation and Blocking

Back in November 2010 I talked about four SQL Server trace flags that I found to be helpful in improving performance for Dynamics AX.  http://blogs.msdn.com/b/axinthefield/archive/2010/11/04/sql-server-trace-flags-for-dynamics-ax.aspx. One of the trace flags I mentioned was 1224. This is the one that changes the default behavior for lock escalation. Since lock escalation is just one of many reasons you…

1

Determining Number Sequence Consumption Rates

In the article, How Preallocated Number Sequences are cached in AX; we discuss setting up pre-allocation of number sequences in Dynamics AX.  One of the difficulties in configuring pre-allocation is determining what to configure the value to.  The Performance Analyzer for Microsoft Dynamics tool is capable of determining how many numbers are being consumed per…