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