• Sue_H - Wednesday, April 25, 2018 3:45 PM

    AndrewL65 - Tuesday, April 24, 2018 4:35 AM

    With GDPR looming my company has agreed that we need some auditing software to record access to data etc.  I'm currently reviewing a couple of products to audit our SQL Servers. they are:

    Idera's Compliance Manager
    Apex SQL Audit

    Was wondering if anyone has experience with either of them?

    My main concern will be performance on our live systems.

    Regards

    Andrew Lackenby

    I used Compliance Manager before. It didn't have much of an impact on performance. That was our biggest concern as they were for pretty active databases. They let us run it for free longer than usual just so we could keep monitoring that.
    Auditors loved it, the canned reports were great and it is probably the easiest one to configure - or used to be anyway. 

    Sue

    Thanks for the take on that, Sue.  We may have such a thing coming up and a recommendation from someone like yourself will carry a bit more weight than mine alone... especially since I've not used such a product before.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)