October 9, 2009 at 11:16 am
Hello!
I would like to implement SQL Server auditing using DDL triggers (capture DML, permission, etc. audit log). I was wondering how much overhead this would add. I am planning to implement DML trigger for each user defined database and on server level. Our environment is high transactional OLTP SQL Server 2005 SP2.
Comments are appreciated,
Igor
October 9, 2009 at 11:52 am
What are you planning on logging? If it's a simple insert of the event, the overhead is supposed to be minimal. Keep in mind that these actions trigger events and they (should) be relatively rare occurrences.
These are DDL triggers, CREATE, UPDATE, etc. statements. These aren't for "INSERT or SELECT" statements. For those you would need a trace of some sort and the overhead will depend on if you log to a table/file, amount of logging, etc.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
October 9, 2009 at 1:59 pm
Steve,
I am planning to capture DDL_DATABASE_LEVEL_EVENTS and DDL_SERVER_LEVEL_EVENTS. I understand that those are much less frequent events than ones captured by DML triggers, but I am still concerned because out system is high transactional OLTP.
Thanks,
Igor
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply