Database Auditing RRS feed

  • Question

  • Hi,

    I would like to know the possible solutions for this scenario below regarding database auditing

    Our requirement is to audit SQL Server databases when

    • Update
    • Insert
    • Select (View)
    • Delete rows from table
    • Rename
    • execute

    statements occur on the database with the following information as the output 

    • Username,database_name
    • Date and time (dd-mmm-yyyy) (hh:mm:ss)
    • The action carried out
    • how long the process took to complete

    These databases are very huge(1.5 tb)

    I am currently exploring database auditing feature at the moment that fits all the needs except for 'how long the process took to complete'. any suggestions? 

    Any other suggestions(apart from DB Auditing) on how to achieve this?



    • Edited by bhanu_nz Monday, August 17, 2015 11:40 PM
    Monday, August 17, 2015 11:39 PM


All replies