Table Metadata Export for Dynamics 365 for Finance and Operations (D365FO)

To be able to review the table and index application properties for D365FO tables and indexes (e.g. table caching, index fields, etc.), I created a new x++ class based on the previous AOT export in the Dynamics Performance Analyzer (step 10 in https://blogs.msdn.microsoft.com/axinthefield/dynamicsperf-2-0-installation-for-dynamics-ax/).

It can be downloaded from Github (assumes some basic development knowledge):
https://github.com/glenturnbullazure/D365FOPerf 
File: D365FO_AOTExport.zip

Like the previous version created by Microsoft Premier Field Engineering for AX 2012, it depends on a separate database to store this metadata, which is essentially a cut down version of the original DynamicsPerf database containing only the relevant tables and views for the purpose mentioned above. There is a SQL solution included in the above download for this reason.

The following steps can be completed in a development environment on your Production deployment path:

Preparation steps

1. Log in to your development VM via RDP using the local admin account details from Lifecycle Services (LCS). Further details

2. Download the zip file and extract it to a folder you can access from SQL Server Management Studio (SSMS) and Visual Studio.

SQL scripts

1. Open SQL Server Management Studio (SSMS). Click File>Open, Project/Solution.

2. Browse to the location where you extracted the zip. Select the SQL solution file, click Open.

3. In Solution Explorer, open the 1-Create_Core_Objects_365.sql script.

4. This will create the DynamicsPerf365 database and objects within it which are populated by the AOT export class (in the axpp file – see next section). Execute the script.

5. In the Solution Explorer, open the 2-Create_Table_View.sql script – this creates one view to make the table data more readable. Execute the script.

X++ class

1. Open Visual Studio.
2. Import the axpp file from the path you saved it to in the first section above.

3. Click View>Solution Explorer. The imported project will appear.


4. Select the AOTExportD365FFO class within the project.

5. Right click on the class, then select properties. Ensure it is set as a startup object. Change the model if required. Click OK.

6. Right click the class again, then click Open. Select Debug > Start Without Debugging to open a dialog in a new browser window.

7. Fill out the dialog accordingly including batch setup if required, then click OK.

8. The operation should complete after around 5 minutes. If you want to monitor the record counts for the tables in the meantime, you can run the following SQL queries against the DynamicsPerf365 database:

Use DynamicsPerf365
select count(*) as index_detail_count from ax_index_detail with (nolock)
select count(*) as table_detail_count from ax_table_detail with (nolock)