Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
In CRM 2015 on Premise we run in to the problem of large POA table. We have over 200 mln records in this table and most of them (170 mln) share records of one custom entity that have already been deleted. Deletion Service trays to delete these records but fails after 1-3 days due to timeout or low disk space. We decided to delete these thro SQL. We found official script from crm 2011: support.microsoft.com/.../2664150 and his faster version: dotnetdust.blogspot.com/.../lessons-learned-deleting-312-million.html .On test environment using the faster method (two indexes change were required) we successfully cleared POA table in 6 hours. Before we run this in production we have a few questions: Did anyone have tried those scripts in CRM 2015? Are they safe in CRM 2015? Is there other, more safe method for this CRM version?
POA table structure hasn't changed for years. I would suggest to consider 2 suggestions:
1. Execute that deletion script during not-operable hours or even better during weekend.
2. Take a backup of your CRM DB before executing that script to have recovery point.
Andrii Butenko thanks for your answer.
We are planning to execute script on this weekend. We will have backup but if consequences of this script will come out after fee days restore of database will be no options (to many changes in one work day)…
Sorry, i know it's a very old post
We have a similar situation, just wondering the POA deletion script(Microsoft official script for CRM 2011) was that a success in CRM 2015?
Any issues you faced?
Could you please share it with us
Thanks in advance,
Business Applications communities