Auditing database performance impact

• DBA_Learner

  SSCarpal Tunnel

  Points: 4228

  More actions

  September 7, 2012 at 9:01 am

  #281233

  Can anyone explain me that do we get any performance issues when we implement database auditing on whole database. This database is used very limitedly though..but still I want to know by auditing

  in this format, do we get any performance impact on database or not

  I am implementing auditing : SCHEMA LEVEL AUDITING

  CREATE DATABASE AUDIT SPECIFICATION Example2

  FOR SERVER AUDIT ADEVNTUREWORKSAudit

  ADD (INSERT,UPDATE,DELETE,SELECT

  ON SCHEMA::dbo

  BY public)

  WITH (STATE = ON)

  GO

  If someone could explain me that would be great. Thanks

• Colleen M. Morrow

  SSCrazy

  Points: 2457

  More actions

  September 17, 2012 at 12:19 pm

  #1538769

  Linchi Shea did some great analysis on this very question.

  The performance impact of SQL 2008 R2 Audit and SQL Trace

  He also did a 3-part series on the perils of using synchronous auditing in SQL Audit. Well worth a read.

  Part 1

  Part 2

  Part 3

  Hope these help.

  ---

  
  Colleen M. Morrow
  Cleveland DBA

• DBA_Learner

  SSCarpal Tunnel

  Points: 4228

  More actions

  September 17, 2012 at 1:59 pm

  #1538807

  Thanks for good post..That is whay I would like to go for SQL Server side tracing..