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…


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)…


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

BASELINES with Performance Analyzer for Microsoft Dynamics (DynamicsPerf) are here !!

  Performance Analyzer for Microsoft Dynamics (DynamicsPerf) is built to help resolve performance issues with Microsoft Dynamics products. As currently released it does a very good job at finding the following issues: SQL Configuration Database Schema (indexes) Application Code (limited) Application Configuration Poorly executing SQL statements Given all of this, there were still questions that…

2

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 as field…

2

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 copy of the Dynamics AX Production database and if that database…


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 of…

5

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.dm_os_windows_info                 This…

2