Performance impact by enabling Audit? RRS feed

  • Question

  • Hi All
    I was asked by a customer if enabling Audit on an entity will impact performance. Specifically when creating, updating and deleting data in that entity. NOT search. My initial response was that I don't experience any noticable impact when I enable Audit.

    But it made me think about how this can actually be? I looks like Audit entries are created realtime when saving data changes. If I had implemented Audit logging in a custom entity using real time workflows there is not question that it would have an impact on performance. So how is Audit logging different? Perhaps it executes the logging internally on the database which means that it bypasses the slow CRM web services? That would in my view be a possible explanation?

    Kind regards, Thomas Rath

    • Edited by ThomasRath Wednesday, June 1, 2016 1:55 PM
    Wednesday, June 1, 2016 7:57 AM

All replies

  • Necessarily there is some performance overhead when auditing is enabled, but it was designed to minimise the overhead on data changes. The audit processing (i.e. determining whether to record audit data, and what to write) is done within the CRM platform, and as close to SQL as can be done, so the processing overhead is significantly less that building any other mechanism that would have to go through the web services

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Wednesday, June 1, 2016 3:57 PM