Dynamics AX in the Field
Microsoft Dynamics AX from the Premier Field Engineering team at Microsoft.
AX 2009 Retail
AX 2012 R2
Cumulative Update 7
Data Management Framework
Database growth in Dynamics AX
Database Synchronization Process
Determining Number Sequence
document process in Ax
Dynamics AX 2009
dynamics ax 2012 r3
dynamics ax 2012 r3 azure lcs lifecycle services demo vm
Dynamics AX 4.0
Dynamics AX CRM DynamicsPerf Dynperf SQL Server Performance
dynamics ax deployment instances
Dynamics AX Event IDs
Dynamics Ax Retail
Dynamics AX SL NAV GP Performance DMV
Dynamics DynamicsPerf Dynperf AX CRM Baseline
Dynamics DynamicsPerf Performance Analyzer
DynamicsPerf Dynamics AX SQL Server
DynamicsPerf Dynamics AX SQL Server Premier Field Engineering
lock escalation and blocking
Long Running Queries
Managing the alerts Queue for AX 2009
Microsoft Dynamics AX 2012
Performance Analyzer for Dynamics
Preallocated Number Sequence
SQL Server 2008 R2 SP1
SQL Server 2012
Browse by Tags
Dynamics AX in the Field
Tagged Content List
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...
6 Nov 2014
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...
4 Nov 2014
DynamicsPerf Deep Dive – What’s the impact of running DynamicsPerf on my system?
This is a question that I get asked a lot, and it’s a very natural one to ask. The short answer to this is almost nothing. We are simply collecting DMV data that SQL Sever already has in memory and inserting that into our DynamicsPerf database. For Dynamics AX customers, we are collecting some...
3 Nov 2014
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...
29 Oct 2014
Management Reporter 2012 CU10 for Dynamics AX 2012 is now available!
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 export to Excel enhancements...
7 Oct 2014
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...
26 Sep 2014
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...
21 Aug 2014
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...
8 May 2014
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...
6 Mar 2014
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...
27 Feb 2014
SQL Server Parameter Sniffing with Dynamics AX, just plain evil. (Redux 5-19-2014)
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 usually with a WHERE clause...
9 Jan 2014
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...
24 Oct 2013
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...
7 Oct 2013
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...
18 Jun 2013
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...
1 Aug 2012
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...
20 Mar 2012
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....
24 Jan 2012
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...
25 Jun 2011
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...
6 May 2011
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...
15 Apr 2011
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...
15 Apr 2011
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...
14 Apr 2011
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...
6 Apr 2011
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. ...
28 Feb 2011
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...
17 Jan 2011
Page 1 of 2 (28 items)
© 2014 Microsoft Corporation.
Privacy & Cookies