Home Ask Login Register

Developers Planet

Your answer is one click away!

Thomas February 2016

Audit trail - SQL Server

Is it advisable to use Triggers in SQL Server to implement Audit trail on very frequently updated tables which contains large data? Are there any performance impacts? If not recommended, what are the options for implementing Audit trail?


snow_FFFFFF February 2016

You might want to investigate Change Data Capture. It is native sql server functionality for audit logging.


CDC does add overhead, but it is well though-out overhead. Triggers can get messy very quickly and should be avoided when possible.

Post Status

Asked in February 2016
Viewed 1,216 times
Voted 8
Answered 1 times


Leave an answer

Quote of the day: live life