Use the out of the box SSIS packages for purging old data from BAM ensuring only relevant information is available and that the Performance of the BAMPrimaryImport is the best. You can create SQL Jobs to run this packages which are automatically generated when you deploy your BAM Activities.
