How AOS permissions to the TempDB are handled in Dynamics AX 2012

With Dynamiscs AX 2012, the concept of TempDB temporary tables was introduced to leverage the power of SQL Server. The TempDB database can store temporary tables as opposed to the traditional InMemory tables. But this technique might cause issues if the access to the TempDB database for the domain account running the AOS service is not correctly setup,…

0

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…


IDMF and SQL Server 2016 Compatibility

Greetings, everyone! So there is likely some confusion as to whether or not IDMF is supported in SQL Server 2016.  Some time in August of 2016, a blog was published about this topic.  While this information held true at the time of its publication, there is new information surrounding this. In order for IDMF to…


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…


Management Reporter 2012 CU16 +HFs is now available!

Management Reporter 2012 CU16 has been posted for download. This release includes the ability to use Management Reporter over HTTPS, and includes several quality fixes as well. NOTE:   CU16 will be the last formal CU release for Management Reporter 2012 for Dynamics AX 2012.   Here’s a summary of the new Management Reporter CU16 features: HTTPS…


DynamicsPerf 2.0 Setting Up Security for Remote Collection

One of the new things to be done with DynamicsPerf 2.0 is setting up security for both local installs and especially remote installs using Linked Server.  In this blog, I will be covering the security setup that you will need to have for each type of installation. LOCAL A local install assumes that the DynamicsPerf…

1

DynamicsPerf 2.0 is HERE !!

Performance Analyzer for Microsoft Dynamics 2.0 has been posted DynamicsPerf 2.0 RTM.    I would like to thank the entire Dynamics community and SQL DBAs that have helped during the process of building this new and exciting version of Performance Analyzer.  Everyone in the community has done a great job of contributing to this version…

5

What’s New in DynamicsPerf 2.0 !!

  What?  There is a DynamicsPerf 2.0?  It’s taken 6 months and almost 600 hours of coding time.  This upgrade really is worthy of the 2.0 version. What has changed?  EVERYTHING !!  Don’t worry it still has the same look and feel. So, with that, let me begin to go through the new features.  …

6