Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 release wave 1Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
We are facing strange behavior of our CRM database. Suddenly on February 26th size of our Annotation entity increased from 500 MB to 4.6 GB. We have checked all notes created on this dates and there is only 5 Notes with files under 1MB of size. After that we have deleted all the Notes created from 25th to 27th of February, also we tried bulk delete for old records, but nothing changed. As You can see the File storage for (Notes) remains unchanged for all this period. Now we are out of ideas what else can cause this sudden increase of size. I would be grateful for any suggestions from your side on what can be checked.
Thank You all in advance
I would strongly suggest submitting a case regarding this investigation. The quick rise in the annotationBase table is indeed unexpected. AnnotationBase table stores notes but it consumes a lot of space because attachments to records are stored in this table as well. Please follow these instructions https://docs.microsoft.com/en-us/power-platform/admin/free-storage-space#reduce-file-storage.
If that won't reduce the storage, please submit a new case for this.
Thank You for your response. Correct me if I am wrong but aren't the notes Files/attachments registered as 'File usage' (the bottom part of the screen)? As You can notice We have big decrease of Attachments File usage, it happens because we move attachment files to SharePoint, but from Database usage perspective Attachments decrease was small. If I understand correctly Databese usage calculates only basic fields like Name, File Name, Description etc. If this is correct then it is even more strange that AnnotationsBase growth by 4GB while there were only 5 new records on these days.
Yes, I do agree. I would submit this as a case to our support team and they will be able to review the specific details for this unexplained growth in this table for this specific instance. DataBase usage is calculated with indexing as well, so only our support team will be able to get to the root of this behaviour.
Business Applications communities