Overhead on Server Auditing

• Erin Ramsay

  SSCrazy Eights

  Points: 9728

  More actions

  February 22, 2011 at 10:27 am

  #234045

  Does anyone have a link or information about the overhead involved when you turn on server auditing with something like:

  ALTER SERVER AUDIT Test_Server_Audit

  WITH (STATE = ON);

  I realize it's partially dependent on how active a database is but just how much overhead are we looking at?

  Don

• danschl

  SSCertifiable

  Points: 5770

  More actions

  February 22, 2011 at 12:45 pm

  #1290051

  http://msdn.microsoft.com/en-us/library/dd392015(v=sql.100).aspx

  this has workload vs trace

• Erin Ramsay

  SSCrazy Eights

  Points: 9728

  More actions

  February 22, 2011 at 2:19 pm

  #1290124

  Perfect! Thank you!