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
How to manage Windows NLB when AOS Service stops
Consider the following scenario where there is an AOS Cluster configured for Services' high availability by following the information published at “Configuring network load balancing for services AX2012” ( http://technet.microsoft.com/en-us/library/hh397322.aspx ) The NLB cluster is working...
16 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
Management Reporter 2012 CU9 for Dynamics AX 2012 is now available!
Management Reporter 2012 CU9 has been posted for download! This release contains enhancements to the Management Reporter Web Viewer around opening and refreshing reports along with additional troubleshooting information in the Configuration Console related to data issues in Dynamics AX. Here’s...
13 May 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
Efficient Dynamics AX Application Lifecycle Management approaches with Team Foundation Server in the cloud
Premier Field Engineering is delivering many Code Review for Dynamics AX all over the planet. One thing we often face is the fact that a real Application Lifecycle Management (ALM) approach is not in place . Real application lifecycle management and even a proper version control with Team Foundation...
24 Feb 2014
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...
20 Feb 2014
Drip, Drip, Drip time to patch SQL 2012 SP1
For those Dynamics customers on SQL Server 2012 Service Pack 1 or above, Cumulative Update 7 is released http://support.microsoft.com/kb/2894115 . There are 2 memory leaks that have been patched that impact Dynamics AX: http://support.microsoft.com/kb/2881661 http://support.microsoft.com...
19 Feb 2014
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...
18 Feb 2014
Dynamics AX and little Orphaned SPID Annie
One of the top questions I am asked by customers when I am on site is what causes AX Orphaned SPIDS and what to do with them and how to identify them. As we know Orphaned SPIDS can cause blocking which lead to end user frustration. They are usually caused by users not exiting the AX application correctly...
13 Jan 2014
Dynamics AX 2012 Cumulative Update 7 (CU7) is now released!
In case you missed it, I’m happy to relay we recently released Dynamics AX 2012 R2 Cumulative Update 7! CU7 includes enhancements to several modules or feature areas, including the highly anticipated Data import, export, migration improvements , and integration with Lifecycle services . AX 2012...
4 Nov 2013
We Are Hiring!
Are you ready to be a Rock Star?? Do you enjoy supporting Microsoft technologies and sharing technical information with others? Are you a motivated individual who enjoys working in a team-oriented environment? Are you passionate about working with customers and solving complex situations? Do you enjoy...
4 Nov 2013
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...
16 Oct 2013
Payroll for Dynamics AX: New Tax Updates available
New tax updates for Payroll for Dynamics AX are available for download. Find the latest updates at the links below. Enjoy! Microsoft Dynamics AX 2012 US Payroll The AX 2012 Payroll tax update 2013-R11 contains the updated tax engine. AX 2012 Payroll tax update 2013-R11 now available (KB2872380...
2 Aug 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
The Microsoft Dynamics AX Technical Conference 2012 is coming soon!
We're getting close to the launch of Microsoft Dynamics AX 2012 R2 and the opportunity to learn all about it (and AX in general) at the Microsoft Dynamics AX Technical Conference 2012. This year's event will be held in Bellevue (Seattle), WA where you'll have access to the best and brightest minds on...
23 Jul 2012
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...
13 Jan 2012
Performance Analyzer 1.10 for Microsoft Dynamics
We would like to announce the release of Performance Analyzer 1.10 for Microsoft Dynamics. This new and exciting release has a long list of new features: Peformance Analyzer 1.10 NOTE: SQL Server 2008 and above only for this version. · An hourly capture of data that shows your transaction...
10 Jan 2012
Interviewing AX Candidates - What I Look For (Part 1)
As I mentioned in the post about tamping someone up on AX, I look for candidates who have expertise in AX Performance, AX Application (at least one particular module) or AX development. Because of this, we have to bring in the right people on the team and ask the right questions to determine if our candidate...
10 Nov 2011
Ramping Someone Up on Dynamics AX
What does it take to learn Dynamics AX? It's not for the faint of heart - the product takes years to master and there's still no one I've met who knows every inch of it backward and forward. First, you have to start by finding the right candidate, so you have to know what you're looking for. Let's...
8 Nov 2011
Page 1 of 2 (34 items)
© 2014 Microsoft Corporation.
Privacy & Cookies