The table
"searchtelemetry-Analytics" (~9GBs) suddenly popped on our database capacity graph earlier this month. Due to that our storage capacity fell down the threshold.
Initially I performed a quick cleanup of other tables emails, tasks, system jobs etc. as I'm unable to find these
"-Analytics" anywhere, to bring our storage back to normal while continuing the investigation into these tables.
I found that there have been ~750 new tables having
"-Analytics" as the suffix in our production database in the past few months. These are some of those tables that take up the most amount of storage
"searchtelemetry-Analytics",
"audit-Analytics",
"activityparty-Analytics",
"activityparty-Analytics".
After, a lot of back and forth with Microsoft support they shared some information on these tables.
- Tables with names ending in “-Analytics” contain data that pertains to predictive insights and/or analytics dashboards.
- When an Analytics or Insights feature is enabled in Dynamics 365, these tables are created and the data is synchronized from Dataverse entities into Azure Data Lake Storage based on “-Analytics” tables. The data is then used for generation of analytics or insights. These are Customer Insights/Analytics tables.
- They mentioned that the "D365 Sales Insights Add-On" might be responsible for those and turning it off will probably stop the tables from getting populated. I haven't gotten any specific information on that to move ahead with it, also we currently use predictive scoring as well.
- Microsoft mentioned to turn off the solutions to remove the data from these “-Analytics” tables but, I'm unable to find those tables/solutions anywhere.
I tried Microsoft's solution found on the help/support page to find the tables mentioned below:
Going through these steps I believe I should those
“-Analytics” tables and use this to pin-point the solution and go ahead and turn it off if it's not affecting business operations. But, I don't see these tables in here. I'm not sure if this is how it's supposed to be used, any advice would be appreciated.
Recent update from Microsoft support:
To create a power automate flow that turns off the 'Azure Data Lake Storage' sync for the entity
"entityanalyticsconfigs". I'm just waiting for them to confirm this as it seems like a hit and trial method, haven't received any solid confirmation or documentation on this.
My Questions?
My understanding is that there is some analytics/insights feature that got turned on, due to which these tables started storing data. Checking within the team, we're not aware of any feature being turned on around the date this issue started. Also, checked with our analytics team and they don't use these tables either.
Q1. What is that specific functionality or feature that is responsible for these “-Analytics” tables? How do I find it?
Q2. How to access these “-Analytics” tables which are nowhere to be found?
Q3. How to purge the data in these tables? Unable to find them through the D365 bulk delete/advanced find UI or any tools within XrmToolBox.
I would greatly appreciate any advice if someone from the community/Microsoft support know how to tackle this. My hope is to get some clarity from the community while I continue investigating this.
If you have any questions, let me know. Thanks!
Share
Report
All responses (
Answers (
717
