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 Feedback

We would love to hear from everyone that installs DynamicsPerf 2.0.  Please leave your feedback in the comments of this post.  Please add the following: Dynamics Product/Version SQL Version How has DynamicsPerf helped you? What would you like to see added next? Please post any defects on the ISSUES page of the DynamicsPerf on Codeplex…

22

SQL Server Parameter Sniffing with Dynamics AX, just plain evil

I do not want to write a novel or a technical manual on Dynamics AX and SQL Server Parameter Sniffing and the problems it causes so I try and keep this as short as possible. When Dynamics AX X++ code in converted in TSQL cursors it is usually in the form of a SQL Statement…

21

Dynamics AX Tracing (Part 1)

Dynamics AX has a tracing feature that allows you to generate ETW traces of the client and server activity on your system. The information collected in these traces includes a call tree, SQL statements, and durations for all of the different code that executes. This kind of trace data can be extremely useful when troubleshooting…

18

DynamicsPerf needs your HELP !!

We REALLY, REALLY, REALLY want to hear from you !!! I need your help in defining a list of new features for DynamicsPerf.  Please leave comments below explaining what you would like to see and what impact that feature would have on the Dynamics community.    Here are a couple of items on my agenda…

14

Windows 7 : How to document process steps outside Dynamics AX 2009

Dynamics AX:  Feature called ‘Task recorder’ to record activities & process done inside product. Path: Dynamics Ax > Tools > Task Recorder   Record steps out side Dynamics Ax 2009 in Windows 7 operating system as following: Windows 7 Operating System: Go to  Windows > Start > Search = psr Click ‘Enter’ Click ‘Start Record’…


Management Reporter 2012 (AX 2012) vs Financial Reporting (Dynamics 365 for Operations) FAQ

Recently we had the privilege of sitting down with one of our partners to discuss the new Financial Reporting functionality in Dynamics 365 for Operations (aka Management Reporter for AX 2012). Although the name has changed in Dynamics 365 for Operations, the core of its purpose and functionality remains intact.  However, during our review, questions did surface pertaining…

13

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…


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

Inventory Costing in AX 2009

I wanted to explore some scenarios that illustrate a few important concepts related to inventory costing– look at differences between physical and financial inventory, and how this affects inventory values. Please reply to the post if you have questions or comments, or if you are interested in additional posts on this topic. This is not intended…

13

Dynamics AX/SQL Maintenance Scripts

  Attached are the Maintenance Scripts I described in my EaaS Video “Microsoft Dynamics AX and SQL Server Maintenance Plans”   1.   SP_STATISTICS_MAINTENANCE 2.   SP_INDEX_MAINTENANCE_ENTERPRISE       a. Requires parameter values be set 3.   SP_INDEX_MAINTENANCE_STANDARD       a. Requires parameter values be set 4.   SP_DBCC_CHECK_DB       a. Requires parameter values be set       Database Maintenance Script.zip

12

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…


Reconciling Inventory to GL in Dynamics AX

This year at ConvergenceI learned that a low percentage of AX customers are aware that new reports have been developed to assist with the inventory reconciling process. I’m hoping this post will help spread the word. Included in this post is the material I covered in my session at Convergence this year: ‘Inventory Costing &…

12

Management Reporter 2012 CU11 for Dynamics AX 2012 is now available (Hotfix 4 Update)

Management Reporter 2012 CU11 (version 2.1.11000.32) has been formally posted and ready for customers to download (NOTE: 4 Hotfixes have been released for this CU release. Please review the details of each Hotfix below).   *****CU11 Hotfix 4 is now available*****  A final optional hotfix rollup is now available for Management Reporter 2012 CU11. This hotfix contains…

11

Performance Analyzer for Microsoft Dynamics 1.20 Deployment Guide Dynamics AX Installation

INTRODUCTION Please be sure to install the core components of Performance Analyzer for Microsoft Dynamics before completing this guide. http://blogs.msdn.com/b/axinthefield/archive/2014/05/29/performance-analyzer-for-microsoft-dynamics-1-20-deployment-guide.aspx Performance Analyzer is delivered as a SQL Server solution file and includes a set of SQL jobs, X++ classes, VB scripts, and performance counters to initiate the collection process. It also includes a set of…

11

Dynamics AX Trace Parser (Part 3)

In part 1 of the series I discussed the basic prerequisites for capturing an AX trace. In part 2, I discussed how to collect a trace. In this post I’ll walk you through the process of importing a trace into Trace Parser and show you a few different things I look for when I start…

11

Dynamics Ax 2009 Financials : Year-End process

Please find the Year-end closing process below: Step 1: Create a new fiscal year   Path: Dynamics Ax > General Ledger > Setup > Periods > Periods       Click button ‘Create new fiscal year’         Click ‘OK’   12 monthly lines get created with open status.     Step 2: Control transactions…


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

Compatibility Testing for Microsoft Dynamics AX

[Updated for SQL Server 2012 and SharePoint 2013]   When reviewing the Dynamics AX environment on customer site, we are often been asked question such as: “Do you know if this version of the product is officially supported by Microsoft”? This is quite natural because Microsoft products don’t have the exact roadmap and General Availability…


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

Patching Strategy for Dynamics AX

Innovation vs. Disruption One common challenge we are facing with large Dynamics AX implementation is the Patching Strategy. Our Premier Mission Critical customers have clearly reiterated the importance of delivering innovation without disrupting their critical business processes. Financial and logistics processes must run continuously, with limited window allowed for system maintenance such as applying application…


Setting Dynamics AX 2012 R3 Demo with LCS and Azure

Hey all you Dynatics (Dynamics Fanatics) out there! With the announcement today I thought I’d drop a quick start guide for setting up the Dynamics AX 2012 R3 Demo Virtual Machine (VM) on Azure to save you a few minutes. The full guide is here: http://technet.microsoft.com/en-us/library/dn741578.aspx Prerequisites and warnings now: This Demo setup uses Lifecycle…


Capture Database Blocking with Performance Analyzer for Microsoft Dynamics

Performance Analyzer 1.0 for Microsoft Dynamics is the tool used by Microsoft Dynamics support, Premier Field Engineers, and product team members to diagnose performance issues with Dynamics products. The following is a step-by-step guide to capturing blocking information with this toolset on your SQL Server environment.  This tool will capture blocking information for any SQL…

9

Performance Analyzer for Dynamics

Our Dynamics Services team has been doing Performance services for customers over the past 10 years.  We’ve learned a lot in that time – what information to collect, what key pieces of data to focus on and how to analyze all this data.   Over the evolution of SQL Server and our products, we’ve used a…

8

Top 10 issues discovered from Dynamics AX Code Review

Three years ago, the Premier Field Engineer team started the delivery of the Dynamics AX Code Review for Premier customers. It has been quite an interesting journey seeing many customization from different instances. Today I would like to step back and reflect on some of the most common issues.If you are a senior developer on…

8

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 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

Management Reporter Version/Feature/ERP Compatibility Overview

The quarterly RU/CU releases of Management Reporter, over the last five(5) years have introduced many new features and supported scenarios. To help you and your team, the MR Program Management and Customer Service teams have created a summary cheat sheet that covers what version contains a feature a customer is interested in and the Dynamics…

7

Determining Disk Latency with Performance Analyzer for Microsoft Dynamics

Are you having slow disk performance with your Dynamics Product?  Do you even know if you are? SQL Server data management views can help you determine if you are having disk latency issues without needing to run Windows Performance Monitor.  The DMV that can help us determine this is called sys.dm_io_virtual_file_stats.  This DMV keeps track…

6

Dynamics Ax 2009 Retail Error Messages & Possible resolutions

Dynamics Ax 2009 Retail Error messages & Possible resolutions:   Error Code Title Error Description Possible Resolution 0                  Error on sending   request The distribution server for the location has not been specified in Retail Scheduler. Modify the location by specifying the distribution server for the location (Retail scheduler >  Common forms > Locations). 4096       …


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

AX 2009 – How to Transfer Security Settings to a Production Server

Summary:  If you are in a situation where you have created your AX security settings on another AX instance and you now need to move them to your production server, below are a few options for how to accomplish this.    Assumptions:  This is a one-time transfer from the STAGING server to the PRODUCTION server…

6

How to solve AX Data Refresh with Powershell?

The number of resources regarding PowerShell with AX, at our disposal, is so small and it is so little we can do with them, this is a topic that I would like to increase awareness starting an open discussion. I will try to bring to the blog scripts that have been helping me to optimize…


What’s New in DynamicsPerf 2.0 !!

  What?  There is a DynamicsPerf 2.0?  It’s taken 6 months and almost 600 hours of coding time.  This upgrade really is worthy of the 2.0 version. What has changed?  EVERYTHING !!  Don’t worry it still has the same look and feel. So, with that, let me begin to go through the new features.  …

6

Dynamics AX Tracing (Part 2)

In part 1 of this series, we covered the basic prerequisites of taking a trace. In this post I’m going to cover some best practices around capturing trace data and how to troubleshoot some common issues that may prevent trace files from being created. The steps below apply to both Dynamics AX 2009 and Dynamics…

6

Top 10 issues raised from Infrastructure Design Review

The Microsoft Premier Field Engineer team helps customer to proactively secure their Dynamics AX 2012 deployment with the Infrastructure Design Review. This service focus on hardware and software requirements to meet business needs. The assessment can help customer to secure the implementation phase for new installation, but also to anticipate increase of workload and user…


DynamicsPerf 2.0 is HERE !!

Performance Analyzer for Microsoft Dynamics 2.0 has been posted DynamicsPerf 2.0 RTM.    I would like to thank the entire Dynamics community and SQL DBAs that have helped during the process of building this new and exciting version of Performance Analyzer.  Everyone in the community has done a great job of contributing to this version…

5

Time to patch SQL Server 2012 Service Pack 2

It’s time to patch SQL Server 2012 installations again.  There is one critical data corruption issue, a fix for Always On, SSIS bug that impacts DIXF and a new performance trace flag.   Here are the relevant KBs for SQL Server 2012 Service Pack 2 Cumulative Update 1:   Data corruption bug rebuilding clustered indexes online…

5

SQL Server Trace Flag 2371 for Dynamics AX

In my travels around the country from one Dynamics AX customer to another the customer is usually aware of how important database Statistics are to the overall performance of Dynamics AX.  The one thing I do not find though is Trace Flag 2371 enabled (or even know that it exists) or an in-depth understanding of…

5