web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Reduce Segmentexecutio...
Customer experience | Sales, Customer Insights,...
Unanswered

Reduce Segmentexecution Database

(1) ShareShare
ReportReport
Posted on by CU13030724-0 29
Hi everyone,
the Table msdynmkt_segmentexecution grows with every segmentexecution and  as i understand, there is only growth. No auto clean-up, except for deleted Segments. 
When you have a lot older but still in use Segments, the Table can take some amount of memory. 
Is there a possibility/setting for reducing the entrys? Maybe by saying: we only need the last month as a history. We are not interested in the History older then that.

Or is it possible to delete everything older than a month directly from the table in the database? 

Best Regards
Stefan
 
I have the same question (6)
  • Community member Profile Picture
    Community member 2 on at
    Reduce Segmentexecution Database
    We have the same problem and its strange that no more have the same problem. 
  • Suggested answer
    Alex Gi Profile Picture
    Alex Gi 7 on at
    Reduce Segmentexecution Database
    We’ve had this problem too, and discussions with support haven’t helped us... CIJ behaves strangely on this point because the logs are basically written into dataverse, and if you have a lot of segments, especially ones that have been active for years, the storage consumption grows massively.
    We managed to work around this by setting up a regular bulk delete job that runs daily and deletes everything in msdynmkt_segmentexecution with finishedon older than day X.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 149

#2
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 132

#3
Tom_Gioielli Profile Picture

Tom_Gioielli 123 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans