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…


Backup and Restore Strategy for Dynamics AX

Your organization’s deployment of Dynamics AX is going to be one of the most important applications in your enterprise (if not, it is the most important application).  It is absolutely critical to the health of your business that a sound backup and restore strategy is in place for your implementation of Dynamics AX. Ensure that…


How to change your Management Reporter Data Mart scheduling for Dynamics AX 2012

In this blog post, I would like to explain how you can view and edit the frequency of the Management Reporter Data Mart. The Data Mart is basically the data provider to integrate information from Dynamics AX operational database. During the installation of Management Reporter, new databases are created [ManagementReporter] and [ManagementReporterDM]. The frequencies of the…


Capacity Planning for Dynamics AX

Since Microsoft Dynamics AX 2012 was launched in 2011, hundreds of Premier customers engaged Premier Field Engineering team to provide guidance on new Dynamics AX 2012 infrastructure, especially when upgrade was executed from legacy versions such as Dynamics AX 2009. Today, most of our customers are live and look for optimization of their existing infrastructure, they need to better justify cost associated with IT capacity and they…


Microsoft Dynamics AX 2009/2012 – SQL Server 2008 R2/2012/2014 Configuration Check List for “Go-Live”

Microsoft Dynamics AX 2009/2012 – SQL Server 2008 R2/2012/2014 Configuration Check List for “Go-Live” Server Level Settings Max Degree of Parallelism Best Practice is that the Max Degree of Parallelism on the production Dynamics AX SQL Server be set 1 Parallelism – When SQL is sent a SQL statement it runs it through the optimizer…

2

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

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


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

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

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

Management Reporter 2012 CU10 for Dynamics AX 2012 is now available!

If you have any question with regards to ERP versions supported by this release, please review the compatibility list here. Management Reporter 2012 CU10 (version 2.1.10001.112 & w/ Hotfix 2.1.10001.126 – see below) has been formally posted and ready for customers to download. This update release for MR 2012 contains enhancements around some of the most voted on suggestions in MSConnect including…


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

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…


BASELINES with Performance Analyzer for Microsoft Dynamics (DynamicsPerf) are here !!

  Performance Analyzer for Microsoft Dynamics (DynamicsPerf) is built to help resolve performance issues with Microsoft Dynamics products. As currently released it does a very good job at finding the following issues: SQL Configuration Database Schema (indexes) Application Code (limited) Application Configuration Poorly executing SQL statements Given all of this, there were still questions that…

2

Dynamics AX and SQL Server Trace Flags, Quick and Dirty

  I searched through this BLOG to find any articles that list and explain all the SQL Server Trace Flags that we Field Engineers may have used or recommended for Dynamics AX.  I found a few recommending and explaining 1 or 2 or the generic Best Practice Trace Flags but no summaries of all of them that we as field…

2

Reduce, Reuse, and Recycle. How to use SQL Server Compression to save (reclaim) drive space in Non-Production Dynamics AX environments.

  NOTE: Compression is only available in SQL Server Enterprise Edition and Higher and also Developer Edition.   Many Dynamics AX Customers have multiple non-production environments used for TEST, DEV, STAGING, UAT, or etc…  For each one of those non-production environments there is usually a full copy of the Dynamics AX Production database and if that database…


TempDB Errors in AOS event log after SQL Server Cluster Failover or AlwaysOn Availability Groups Failover (Update 8/27/2014)

  If you have ever seen errors in your AOS Event Viewer Logs after a SQL Server Cluster or AlwaysOn Availability Groups Failover and wondered why it is happening here is a brief explanation.   Object Server 01: [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the table ‘tempdb.DBO.t855_489F061A83074B41907007FFAE3B5D41’, because it does not exist or you…

5

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

What is my data distribution by company(PARTITON and or DATAAREAID) for a specific Dynamics AX table?

  If you have ever asked yourself the question “What is my data distribution by company(PARTITION an or DATAAREAID) for a specific Dynamics AX table?”, wonder no longer.  Attached is a TSQL Stored Procedure you can add to your Dynamics AX database (4.0, 2009, 2012, 2012 R2…) and then run it against any table in…

4

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

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

New DMVs in SQL Server 2008 R2 SP1 and SQL 2012 (‘Denali’) and Performance Analyzer for Microsoft Dynamics

One of the new features in Performance Analyzer 1.10 for Microsoft Dynamics is support for new DMVs in SQL 2008 R2 SP1 and SQL 2012. In this blog, we’ll explain what the new DMVs are and how they are used in analysis of performance issues in Microsoft Dynamics deployments.   New DMVs: sys.dm_os_windows_info                 This…

2

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

Logon Dialog Box when Launching a Reporting Services Report from AX.

I was recently working with a Dynamics AX 2009 customer who had Enterprise Portal and SQL Server 2008 R2 Reporting Services installed on the same server – a fairly common configuration. Everything worked great except that they were encountering a barrage of logon dialog boxes each time they launched a Reporting Services report from the…

2

Convergence Replay – Database Compression and Encryption

Thanks to the big crowd who attended Michael DeVoe’s Convergence Session on Tuesday on Leveraging Microsoft SQL Server Data Compression & Transparent Data Encryption with Microsoft Dynamics Products.  Yes, the title barely fit on the opening slide :).  The audience asked some great questions and Michael packed a ton of information into 70 minutes of time…

2

Convergence Replay – Performance Analyzer for Microsoft Dynamics

Thanks to everyone who attended Rod Hansen’s session on the Performance Analyzer for Microsoft Dynamics at Convergence.  We had a great turnout and great interaction within the session.  They are still compiling the survey results, but as of last night, Rod’s session was the #1 rated session with more than 10 respondents.  Thanks for the…


Video: How to collect a trace within Dynamics AX

When trying to diagnose performance issues in Dynamics AX, two of the key tools that we use are the Performance Analyzer (for SQL activity), and the Event Trace Parser for Microsoft Dynamics® AX (aka Trace Parser).  Trace Parser is a user interface and data analyzer built on top of the Event Tracing for Windows (ETW)…

2

Podcast: Leveraging SQL Compression with Microsoft Dynamics Products

We are podcast crazy this week on the Premier Field Engineering for Dynamics team.  The PFE team will have a podcast a day going this week to get everyone jazzed up for Convergence next week.   Our Dynamics AX focused podcast centers around using the compression capability available in Microsoft SQL Server 2008 Enterprise Edition.  With compression you can…

1

Setting up 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 installing this toolset on your SQL Server environment. This tool is delivered as a SQL Server solution file and can…

4

Database Mirroring with Dynamics AX

Is the AOS a “mirror aware” service? If so, what’s the user experience when a failover happens? These are two of the questions I recently received from a customer as they were planning their database high availability solution.  When it comes to database high availability for Dynamics AX, a SQL cluster is by far the most…

2

Degraded Performance on Dynamics AX and the SQL Server TokenAndPermUserStore

[Ed. Note – this is a repost of an article Michael DeVoe posted to the NAV Team blog, but it applies equally to Dynamics AX] I recently came across an issue with a large Dynamics ERP customer where queries were becoming slower over time, and blocking significantly increased.  After going through the normal troubleshooting activities,…

2

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