SQL Table ADPEvent is over 800GB!!

[Arfer99]

Does anyone have any ideas why my ADPEvent table would be so big? It seems to be keeping around 44 days of event logs in this table.

I cannot find anywhere that specifys the data retention period of 44 days. How can I prune this down as the HDD that hosts the SQL Data file is almost full.

[Arfer99 · Accepted solution]

As no one bothered to answer I had to find out myself.

The Intelligence service within the Console had topped working and the data wasn't being extracted to the cloud. Opting out of Intelligence and truncating the tables resolved the issue.

[AaronWhittaker]

We had the same issue but solved it in a different way.

After a rather long VMWare support ticket, they informed us that the job 'ADP Export' should NOT be enabled. This was meant to be disabled as part of the install, but apparently some times it doesn't. After disabling the job and truncating the table, it all cleared up.