Not sure if you are the person to go t, but you are listed as one of the Space Admins so thought I would start somewhere.
Do we have anyone that can provide some assistance to an On Premise customer with regards to their Analytics Database questions?
Any and all help appreciated.
If I had to guess, the tables taking up the most space are jivedw_activity_fact and jivedw_activity_agg_day.
jivedw_activity_fact is the raw activity feed from the app. It is used to fill the rollup table jivedw_activity_agg_day (and week and month).
If they don't mind the loss of fidelity, they can safely remove the older records from activity_fact (and potentially agg_day) - they would still have their monthly rollups from the past...
As far as the built in functions, I am not sure what the expected functionality is there so can't comment...
Much appreciated. I will go back to the customer with this information.
Further to my update of yesterday.
I took your information back to the customer and they have responded with the following:
Hi Richard, thanks for the reply. It is a good step forward to identify the largest tables.
From the response though, I'm a little concerned how safe it is to remove the data, as we certainly do not want to break anything beyond putting the retention period in place which we expect to reduce the data usage.
Could you provide some more detailed information about the exact impacts of removing data from these tables? We'd like to be better convinced that manual removal of data from these tables will not introduce additional side-effects.
For example, has this ever been done elsewhere successfully?
Is it possible to answer the customers concerns here?