Showing posts with label InMemoryTable. Show all posts
Showing posts with label InMemoryTable. Show all posts

Performance Tool in D365FO


Performance Tool in D365FO
Today, I found standard feature of performance optimization in Dynamics 365 For Finance and Operations ....

Microsoft called this feature as Performance tool


You can find the navigation of this tool as below... 


You will find lots of option here to optimization, Over internet I didn't find any documentation of this feature. So I am sharing some items i have explored.

There is Text box where we can Enter of  the number of records on which we want to check performance using this tool.


Microsoft Divide this Feature in 4 Category

  1. Data  Manipulation
  2. Query
  3. Temp DB & In Memory
  4. Cache 


Data Manipulation

In this MS Checking the performance of 
Insert  
Update
Record Insert List
 Insert Record set
update record set
delete from


Query

In this section testing will perform on the below points


  1. Large Buffer read
  2. Cluster Index
  3. Unique index with cache hit
  4. Unique index without cache hit
  5. Non-Unique Index

Temp DB & In Memory

In this section we can check the performance on Temp DB and In Memory....  

Cache

The same number of records will store in cache ...


Important 
Note that running for 1,000 records will take approximately 1 minute, so be careful using larger numbers not to run into form timeouts. The max record count is 100,000.

Support Faryal's Cusine


Virtual Fields Vs Computed Fields

  Virtual Field: A virtual field in D365FO is a field that doesn't have a direct representation in the database. It's a field that y...