We are trying to resolve an issue with capacity related to the Activity Pointer Base table - below is a recap:
Our Activity Pointer Base table size is disproportionate to the the activity tables that roll up to it. Row comparisons are equal but he size is off - the Activity Pointer Base is significantly larger than the rollup tables.
Have engaged Microsoft support who's only recommendation is to delete emails to reduce the activity pointer base table size.
Here is a summary of the database table size information as of January
- The activity pointer table comprises all individual activity tables - So the Activity Pointer table size should equal the sum of all the individual activity table sizes – and it does not.
- The sum of all the individual activity tables size = 1,823 MB
The activity pointer size = 73,919 MB - Even if I summed up size of all tables (minus Activity Pointer) it is only 31,000 MB, if all tables equals no more than 31K MB how can Activity pointer be over 73K MB
Has anyone else ran into this problem? The only advice from Microsoft is to delete Emails, but then we lose historical information. And deleting would not solve the disproportionate size issue.
Waiting for final word from Microsoft - several steps were taken on their end to troubleshoot - they acknowledge that there is a discrepancy in the size of the tables, but have stated the table is performing as expected that there are not issues with the indexes or sync jobs between APB and individual activity tables.
