Clean up PrincipalObjectAccess in CRM 2015 RRS feed

  • Question

  • With CRM 2015 On Premises our PrincipalObjectAccess table has grown to about 12M rows, and I've read about possible performance issues after 10m.  How can we go about cleaning this up?  Something I've noticed is when a share is created then removed it leaves the record in this table with InheritedAccessRightsMask = 0 and AccessRightsMask = 0, which of our 10m rows 4.6m are like this.  I've read various sites where people suggest ways to clean this table, but I haven't found anything related to CRM 2015 or anything that doesn't involve updating the database which we avoid like the plague. 

    So what is the Microsoft suggested or supported way to clean this up?  If just removing the Share keeps the database record in the table is direct database modification the only way?  And if so what's suggested to delete from this table?

    Thanks for any advice.

    Wednesday, April 5, 2017 6:19 PM

All replies