Saturday, May 30, 2020

Power Platform Analytics for Microsoft Dynamics 365 CE Part 2 - Common Data Service Analytics Part 1

This tab shows all common data service calls related statistics for further analysis. Using this developers can get more idea about following areas.

  •     Performance of Plugins/APIs/workflows
  •     Failure or pass rate of Plugins/APIs/Workflows
  •     Entity usage of dynamics CE
  •     User operations
  •     User access modes
  •     Mail box usage
We will describe each and every components in related section.
In the Home section it will show brief summary about Active Users, API Calls, API Pass Rate and Total Executions. Those data you can easily find out in relevant section with more details.


However first you need to set correct date range you need to analyze. You can set date range and environment as filters like following. This will apply for all other tabs and will show historical data according to the filter settings



Active Users Analytics

In this analytic group will show how many active users are in your system. To get more details about graphs I filtered data to single day.
First graph will show how many users are logged in to the given environment. If you select single day it will show data hourly or it will scale up based on the filters you added (e.g. If you select month it will show active users by day.



Following graph shows different operations performed by user based on time scale. This graph will show exact operation count by time and operation. This graph will help to get idea about mostly performed operations by time.


Following graph will show most active users based on the operations performed by user. This will help administrators to identify usage of CRM and who are the users most active. Also it will help to get idea about what are the operations which perform mostly and adjust CRM performance based on the operations. According to the example we have considerable amount of data reads than creates. We can optimize our read queries with “nolock” after some analysis about entities and data.



Total Operation graph helps to identify peak hours which system execute large number of operations. This will help administrators to change resource allocations plans dynamically. If you select filter criteria to years you can observe time periods which generate much traffic.


Total Page Request graph shows how much page requests generate by system/users in forms/reports/dashboards. At the moment current environment did not generate such request. However in live environments will get data in to this graph as well.


Tuesday, May 26, 2020

Power Platform Analytics for Microsoft Dynamics 365 CE Part 1 - Capacity

With recent power platform releases Microsoft introduce great combination of analytics which really helpful to analyze current CE instances and made decisions.

These analytics are crucial to keep CE instance with optimized performance. Also it helps relevant parties to made decisions.

How to navigate to “Power Platform Admin Center”




Then click admin link



Then move to All Admin Centers and open D365 admin center


Then open Analytics Tab

Note: You should have necessary D365 roles to open D365 admin page


Capacity:

In this tab will show database usage analysis. It will show how much disk space you’re used already, how much disk space remains. How much disk space used for database, logs and files. It will list down all the environments in your tenant. Once hover your mouse on the bar chart in bottom will show exact amount of each category (file/database).

Note: As I used trial environment it shows database as exceed. However if you use trial organization database space will not count.

Or you can use Storage Capacity tab to view those capacity data by category.

If you click on the chart icon in front of your CE environment name it will show more detailed analysis about your environment like below.

Note: You can export all these graphs and data through menu icon which placed top right hand corner button.
First chart will show top database usages based on category. User can delete unnecessary files/data based on this figures.



Also using following chart user can get idea about file storage and how it utilized. Based on that administrators can decide to remove unwanted annotations or solutions or any other unnecessary artifact to reduce file storage.


Last graph will show how space utilized for logs (plugin trace log).