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 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
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 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 5/9/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
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...
14 Jan 2011
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 number...
10 Dec 2010
SQL Server Trace Flags for Dynamics AX
The purpose of this post is to list and briefly explain 4 SQL Server trace flags that we've found to be helpful in certain circumstances when working with our Dynamics AX customers in the field. In general, I don't recommend enabling these trace flags unless you're experiencing the specific issues they...
4 Nov 2010
Page 1 of 1 (21 items)
© 2014 Microsoft Corporation.
Privacy & Cookies