CollectionMembershipChanges table growing extremely large and not getting cleaned up (945M rows, 52GB or more).
Last Updated September 09, 2016
When trying to create resource targets, the operation would time out after 5 minutes and result in a 'data could not be loaded' error dialog. Altiris profiler shows that the statement spCollectionMembershipDelete 'EB3A1A12-E1C7- 4431-B060-F0333E4E488C' ran the entire time up to the timeout. Runing sp_spaceused CollectionMembershipChanges shows an extreme table size.