Storage usage issue

(0) Share

Report

Posted on by AndreyAndrey

Hello everyone.

Trying to figure where did the free space go. In pursue to detect the most heavy table in the system I've installed Organization Insights solution from microsoft. It shows top 10 tables by size.

And since then I have a question: what are these table for and how to access them?

- Annotation Base

- Lead Base

- ActionCardBase

- PrincipalObjectAccess

- AuditBase

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (4)

Verified answer

David Jennaway 14,065 on at

Like (1)

Report
AnnotationBase stores Notes

LeadBase stores Leads

ActionCardBase stores data from relationship insights

PrincipalObjectAccess stores information about shared records (this is a record of all shared records

AuditBase stores Audit data

For the audit and relationship insight data, you may well not need to keep historic data, so you could setup bulk deletion rules to clear out this data. For leads and annotations you'd need to check if you need this data. For PrincipalObjectAccess, there's not much you can do if you need to share records, though you may be able to do less sharing by reevaluating how you implement security (for example you may be able to use teams more for security). Note that a large number (in the 100 000s) of records in PrincipalObjectAccess can start to affect performance

Was this reply helpful? Yes No
Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello Andrey та міцного здоров'ячка,

AnnotationBase table stores notes but it consumes a lot of space because attachments to records are stored in this table as well.

LeadBase stores your Leads in CRM.

PrincipalObjectAccess table stores directly and indirectly shared records and this is really bad if you have a lot of shares.

AuditBase stores your audit logs.

I believe you're online so any of mentioned tables are not available.

Was this reply helpful? Yes No
AndreyAndrey 27 on at

Like (0)

Report

Hi, Andrew!)

Доброго і Вам!

You're right - it's online.

"any of mentioned tables are not available" - dоes it mean that we are not able even to export these tables from crm to azure to analyze them?

The problem is that Organization insights shows 13Gb in AuditBase but "Audit log management" shows only 6,5Gb approximately.

What takes other 6,5Gb?

How to free space in the storage?

Was this reply helpful? Yes No
Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (0)

Report

Hello,

You don't need to export it to azure if you want to analyze it you can just ask Microsoft to provide you a backup of CRM DB.

Regarding space consumed - that is a great question. I believe you will get your question answered once backup is available.

Alternatively you can open a ticket with MS to get an explanation.

Was this reply helpful? Yes No
Verified answer

Johnny Gong 6,482 Moderator on at

Like (1)

Report

Hi Andrey,

More information about the mentioned Tables listed above, kindly refer:

msdn.microsoft.com/.../gg328086.aspx

Following link will help you with the 10 ways to free storage for your organization.

LINK: docs.microsoft.com/.../free-storage-space

In addition, you could delete audit logs to free space or use 3rd party toolkit like the SSIS Integration Toolkit which works both on premise and online to store the D365 Audit Log offline

The following Toolkit details are for your reference:

Download Linkage: www.kingswaysoft.com/.../download

Video of Getting Started with SSIS Integration Toolkit for Microsoft Dynamics 365/CRM: www.youtube.com/watch

Hope it helps.

Regards,

Johnny

Was this reply helpful? Yes No
Vipin J 1,603 on at

Like (0)

Report

Microsoft have come up with Power Platform to have more in-depth Storage analysis

Here is how I did freeing up storage space

https://vjcity.blogspot.com/2019/06/cleaning-storage-space-in-dynamic-crm.html

Was this reply helpful? Yes No