Reason 1: Easily identify current performance issues
The first step to solve performance issues is to identify the cause, and this is the administrator’s worst headache. This is because performance issues can occur because of a multitude of different reasons and it can also be due to a combination of events.
Streamline installations are supposed to make our lives easy, that is if they are properly configured.
First question is how to make a streamline installation. These can be downloaded from https://lcs.dynamics.com
One has to create a project. It is important that it is for the correct build (RTM, retail, R2 or R3).
Next, scroll to the right on the LCS site. On the More tools plane, one can...
Yes just a new post about DMF, not really about how it works, just an update on the latest know issues.
What you have to know:
DMF AX2012 R2 and higher the staging table MUST have an one on one relation to the target Table.
The menu item you select in the DMF wizard. Is for jumping from the staging table form to the target Ax Form.
DMF wizard sometimes duplicate the table cache setting of...
We are able to delete a company in AX, but deleting a partition is not possible.
So why not? It should be easy to create a partition and put data in it with tools like DMF, to enable us to create ad hoc demo / training partitions. Having played for a while with some SQL code, the following code was obtained.
First browse the partitions table to find the RecId of the partition one wants to...
Last week, I was upgrading AX 2012 R2 CU7 to CU8 and ran into a model store error. The error was similar to http://blogs.msdn.com/b/axsupport/archive/2014/01/08/violation-of-primary-key-constraint-pk-modelelementdata-elementhandle-error-installing-some-hotfixes-on-microsoft-dynamics-ax-2012-r2.aspx
It scared the hell out of me! First thing that came to mind was: is my model store corrupt in...
We all know indexes on AX tables will improve performance when querying these tables. There are all kinds of fancy features such as parameter sniffing, trace flags, etc. But if we look for example at the ledger Journal Trans table you will start thinking that maybe core dynamics AX has added too many indexes.
When installing SharePoint 2010 a lot of additional DB’s are created. This can be nasty from maintenance point of view, especially when a Central SQL server is used. Take a look at the next picture. This shows the worst case of DB naming. If these DB are stored on a central DB, you have known idea, if those DB are obsolete in one year, because you don’t know who used...
In AX 2012 R2, table inheritance tables are all stored in the same table.
So the Company Info table is on SQL level stored in the table DirPartyTable. They did this for performance reasons. But what happens when you insert a new Colom on that table. We get unretrieved values like below screen.
Normal fields in AX tables are not allowed to be NULL, so there is always an empty string or a zero...