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

Notifications

Announcements

No record found.

News and Announcements icon
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,...
Answered

Reduce Segmentexecution Database

(1) ShareShare
ReportReport
Posted on by CU13030724-0 31
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
    We have the same problem and its strange that no more have the same problem. 
  • Suggested answer
    Alex Gi Profile Picture
    Alex Gi 9 on at
    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.
  • Verified answer
    yocheby Profile Picture
    yocheby 2 on at
    This issue is reported in Microsoft Known issues, and the mitigation is delete data, in my case I'm using Bulk Record Deletion:
     
     

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

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 108 Super User 2025 Season 2

#2
Jimmy Passeti Profile Picture

Jimmy Passeti 50 Most Valuable Professional

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 49 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans