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

DynamicsPerf needs your HELP !!

We REALLY, REALLY, REALLY want to hear from you !!! I need your help in defining a list of new features for DynamicsPerf.  Please leave comments below explaining what you would like to see and what impact that feature would have on the Dynamics community.    Here are a couple of items on my agenda…

14

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 in this…


Performance Analyzer for Microsoft Dynamics 1.20 Deployment Guide Dynamics AX Installation

INTRODUCTION Please be sure to install the core components of Performance Analyzer for Microsoft Dynamics before completing this guide. http://blogs.msdn.com/b/axinthefield/archive/2014/05/29/performance-analyzer-for-microsoft-dynamics-1-20-deployment-guide.aspx Performance Analyzer is delivered as a SQL Server solution file and includes a set of SQL jobs, X++ classes, VB scripts, and performance counters to initiate the collection process. It also includes a set of…

11

Performance Analyzer for Microsoft Dynamics 1.20 Deployment Guide Core Installation

  INTRODUCTION DynamicsPerf (Performance Analyzer) ,http://dynamicsperf.codeplex.com,  is the tool used by Microsoft Dynamics support, Premier Field Engineers, and product team members to diagnose performance issues with Dynamics products. IMPORTANT: The purpose of the Performance Analyzer is to be used on a continual basis so it is important for administrators to understand the components that make…

4

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

2

Time to patch SQL Server 2012 Service Pack 2

It’s time to patch SQL Server 2012 installations again.  There is one critical data corruption issue, a fix for Always On, SSIS bug that impacts DIXF and a new performance trace flag.   Here are the relevant KBs for SQL Server 2012 Service Pack 2 Cumulative Update 1:   Data corruption bug rebuilding clustered indexes online…

5

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 fine and suddenly one of the AOS services stops. The rest of Windows Server components in that server are still up and running. The NLB…

1

Management Reporter 2012 CU10 for Dynamics AX 2012 is now available!

If you have any question with regards to ERP versions supported by this release, please review the compatibility list here. Management Reporter 2012 CU10 (version 2.1.10001.112 & w/ Hotfix 2.1.10001.126 – see below) has been formally posted and ready for customers to download. This update release for MR 2012 contains enhancements around some of the most voted on suggestions in MSConnect including…


Convergence EMEA, November 2014

Hi all, We are pleased to announce that Premier Field Engineer team is going to be at next EMEA Convergence event. This will take place the 4-5-6 of November in Barcelona. You can now Schedule your private agenda with the Convergence Schedule Builder. Here are two sessions that me and my colleagues Steven Vlaanderen Oldenzeel…


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 articles called…

5

Patching Strategy for Dynamics AX

Innovation vs. Disruption One common challenge we are facing with large Dynamics AX implementation is the Patching Strategy. Our Premier Mission Critical customers have clearly reiterated the importance of delivering innovation without disrupting their critical business processes. Financial and logistics processes must run continuously, with limited window allowed for system maintenance such as applying application…


Top 10 issues raised from Infrastructure Design Review

The Microsoft Premier Field Engineer team helps customer to proactively secure their Dynamics AX 2012 deployment with the Infrastructure Design Review. This service focus on hardware and software requirements to meet business needs. The assessment can help customer to secure the implementation phase for new installation, but also to anticipate increase of workload and user…


Using Performance Analyzer for Microsoft Dynamics in a Development, Test, or QA environment

  USING THIS PROCESS WILL KEEP SOME PERFORMANCE ISSUES OUT OF PRODUCTION !!! BE PROACTIVE NOT REACTIVE WITH YOUR DYNAMICS PERFORMANCE !!   Using Performance Analyzer for Microsoft Dynamics in your production environment I think is pretty well understood the benefits of doing that activity.  All of us are constantly trying to tune our production…

2

Commenting in Performance Analyzer for Microsoft Dynamics (DynamicsPerf)

  A little, mostly unknown feature in Performance Analyzer for Microsoft Dynamics, http://dynamicsperf.codeplex.com,   is the ability to add comments to the database.  We have significantly upgraded this functionality in version 1.20 of the toolset.  The intent of this functionality is twofold.  The first being that this is a way to keep track of tasks that…


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

New home for DYNAMICSPERF !!

I would like to announce the new home for Performance Analyzer for Microsoft Dynamics.    http://dynamicsperf.codeplex.com   I have posted our current stable build of version 1.20 to this location.  Please download and use this newer version.  I will have some additional blog posts on this version soon.   Rod “Hotrod” Hansen  


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 a summary of the new Management Reporter 2012 CU9 features: View a list of…


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

Setting Dynamics AX 2012 R3 Demo with LCS and Azure

Hey all you Dynatics (Dynamics Fanatics) out there! With the announcement today I thought I’d drop a quick start guide for setting up the Dynamics AX 2012 R3 Demo Virtual Machine (VM) on Azure to save you a few minutes. The full guide is here: http://technet.microsoft.com/en-us/library/dn741578.aspx Prerequisites and warnings now: This Demo setup uses Lifecycle…


Management Reporter 2012 CU8 for Dynamics AX 2012 is now available

Microsoft’s vision for Management Reporter (MR) continues to mature as a powerful Corporate Performance Management (CPM) solution with greater stability and rich functionality enhancements for Dynamics AX 2012 . This new CU release is a testament that the Product Group for MR is listening and remains sensitive to our customer’s domestic and international Financial Statement (real-time) reporting needs/requirements by…


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…


Financial Reporting by Site – Dynamics AX 2012

  I recently had a partner/customer that came to me with a few things they needed to accomplish in AX 2012 when it came to reporting.  They were running an earlier version of AX 2012 very close to RTM and were trying to make an upgrade decision.  They were going to soon be opening another…


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.DBO.t855_489F061A83074B41907007FFAE3B5D41’, because it does not exist or you…

5

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 Server (TFS) is still a mystery for…

3

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 next release, we will be adjusting…


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/kb/2895494   Dynamics AX uses these features.  I’ve personally seen this at customers with AX 2009 and AX2012.  You can…

5

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 are a senior developer on…

8

Do you need the accrued purchases report in a UK localization in Dynamics AX 2012?

Hi Everyone, Recently I was asked by a customer to look into a securityissue around one of their reports in Dynamics AX 2012 R2.  Users were reporting that some people withinthe customer organization had access to the accrued purchases report and somedid not. After reviewing the security we found that the user that hadaccess to…


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…

2

SQL Server Parameter Sniffing with Dynamics AX, just plain evil

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…

21