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
Management Reporter 2012
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
Management Reporter 2012 CU12 for Dynamics AX 2012 is now available
Management Reporter 2012 CU12 RTM (version 2.1.12000.26 ) has been formally released and ready for customers to download. Please NOTE that this is a Quality Release(QR) focusing on bug fixes only. CU12 contains all of the enhancements and bug fixes from CU11 Hotfixes 1-4 , including: Indication...
24 Apr 2015
Management Reporter Version/Feature/ERP Compatibility Summary Overview
The quarterly RU/CU releases of Management Reporter, over the last two(2) 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...
31 Mar 2015
Management Reporter 2012 Security Review with AX 2012
Below is a fairly detailed review of how Management Reporter 2012 security (users and user roles) are derived and directly correlate from the users created and security permissions assigned in Microsoft Dynamics AX. This review will cover the following topics: •Adding users from AX 2012 ...
2 Feb 2015
Lifecycle Services Diagnostics for Management Reporter and Microsoft Dynamics AX 2012
It is exciting to make you all aware that eight new diagnostics scripts are now included for AX2012 specific to GL and Budgeting that help identify data inconsistencies that cause issues for Management Reporter integrations and incorrect reporting results. These scripts check for invalid data within...
6 Jan 2015
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
Page 1 of 2 (38 items)
© 2015 Microsoft Corporation.
Privacy & Cookies