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

Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series
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 34
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)
  • HR-27040836-0 Profile Picture
    HR-27040836-0 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

News and Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Manoj - ManoVerse Profile Picture

Manoj - ManoVerse 57 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 54

#3
Ayesha Wajahat Profile Picture

Ayesha Wajahat 14

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans