web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Size AuditBase is very...
Microsoft Dynamics CRM (Archived)

Size AuditBase is very big, can I shrink this?

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

I have a little problem with our online D365.

I see in Organization Insights the the AuditBase is about 27 GB and I see that the active audit log is about 7 GB.

Is the AuditBase table something diffrent than the active audit log table?

Can I shrink this AuditBase tablke somewhere?

Kind regards,

Arie

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    I guess you are saying MDF (data) and LDF (log) file?

    There is no splitting of Base table and Extension Base table long long time ago..

    I don't see much problem to shrink the log file, but not the data file. Don't think you can do that if you are using D365 online, maybe you need to log a request to MS for them to do it for you?

    27GB is not too much, but if you have concerns on the growing data audit, please spend some time to review what audit is not necessary and turn them off.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    You can delete audit data using DeleteAuditDataRequest

    msdn.microsoft.com/.../gg334260.aspx

  • Community Member Profile Picture
    Community Member on at

    Sorry for the confuse but we are using Dynamics 365 Online so we don't have access to any MDF or LDF files .... ;-)

    But what I don't understand, you saif 27 GB isn't much but we have an overall use of D365 Online for 50 GB, I think that 27 GB for only to log the changes in the entity's is quit much .....

    But the real question is that I see in D365 Online that we use 7 GB for our Audit logs but why is there than anorther AuditBase log for 27 GB and isn't this last one included in the overall Audit logs ???

    I think that MS should give us a tool where we can see where all our GB's are going too, the only thing I know for sure we use in total 51 GB but MS should know much more where all this data is going to.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Good day

    Firstly, and as others have mentioned, it would be a good idea to review what entities and fields are currently being audited. If some are no longer required, stop them from being audited.

    Secondly, you can delete the old audit logs: https://www.microsoft.com/en-US/dynamics/crm-customer-center/recover-database-space-by-deleting-audit-logs.aspx. The audit log screen does show roughly how big each one is (3 months of audit data per log), so will give a good idea of how much space can be saved. Please note that deleting these audit log files will mean the audit history data is no longer available for that time period.

    If you have to keep the audit history for everything (maybe for a legal reason), then unfortunately you are just going to see it get bigger and have to pay for more storage.

    Hope that helps
    James

  • Community Member Profile Picture
    Community Member on at

    @Vikan, you can delete the audit logs in Dynamics 365 Online in this way: www.microsoft.com/.../recover-database-space-by-deleting-audit-logs.aspx

    Or do you mean something else?

  • Community Member Profile Picture
    Community Member on at

    @James, you were you one minute quicker with that link than I was ....... ;-)

    Secondly, I undestand complety what you mean and how it works but still the main question is still active.

    How can it be that I see for 7 GB for audit log files in the above url you send me and that I see in Settings --> Organization Insights --> Storage, I see an Audit Base table for 27 GB ....

    So one isn't correct or these are different audit log files? It is a little bit confusion and I think that MS should clear this out, not just for me but for everyone who is paying a lot for the extra data consuming ....

  • Verified answer
    ashlega Profile Picture
    ashlega 34,477 on at

    Hi Arie,

     you can't "shrink" the database in CRM online.

     There are some details on how auditing is implemented here:

     msdn.microsoft.com/.../gg309664.aspx

     Every 3 months, audit data will be archived and stored in a partition.. which will be called an "audit log"

     Using the link James posted above, you can delete those logs. You can't delete just any of the logs - have to start from the olders (I'm guessing they are sequential, so CRM might not be able to maintain audit data consistency if we were allowed to delete something in the middle)

     AuditBase is, indeed, the audit table (I'm pretty sure there is only 1 audit table - there is no "active"/"inactive"). Not that it changes anything since we don't have direct access to the database in the online environment

  • ashlega Profile Picture
    ashlega 34,477 on at

    PS. Do you have more than one audit log in that list? What's the total size of those logs? Like I said, there is only one AuditBase - there are just different partitions:

    docs.microsoft.com/.../partitioned-tables-and-indexes

  • Community Member Profile Picture
    Community Member on at

    @Alex,

    I have 5 audit logs:

    1 --> 300 kB

    2 --> 600 kB

    3 --> 1.09 GB

    4 --> 1.12 GB

    5 --> 7.63 GB

    So in total you should expect about 10 GB fot the audit logs.

    But as I said, I see in Organization Insights an Audit log for 27 GB.

    Isn't that a little bit strange? Where is the extra 17 GB coming from?

  • Verified answer
    ashlega Profile Picture
    ashlega 34,477 on at

    Yes, it looks inconsistent. Still, it depends on what is counted where.. I don't know how exactly those numbers are calculated on both sides. For example, I'm wondering if index size is included into those 5 numbers you posted (and it might be included into the 27GB)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans