ActivityStreams_Primary is currently at approx 120GB. I only have Enterprise installed, no social or anything else. So is this size normal, can it be shrunk?
Did you ever get an answer or find a solution to this? My ActivitySreams table is currently over 500GB and growing exponentially. I am wondering as I don’t know that I need any of this information if there is something in Epicor/SQL that can be turned on/off to keep it from writing to this table. This morning I did a query to return records from a single day in September to see what data that is being written and it took 13 minutes to return almost 2 million records of random errors and information.
In case anyone else runs into this in the future, I got the answer from Jatin at Epicor. The ActivityStreams database is populated by Epicor Social which we don’t use. There are fields in the Epicor database that determine if records will be written to ActivityStreams. You can find them in the [Epicor Database].cdc.CaptureStatus table. You will see a list of TableNames and CaptureEnabled set to either True or False. All of ours were set to True. Set them all to False and poof, no more records being created. Now I just need to clean up this trillion record table. 