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?

Answers


snow_FFFFFF February 2016

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

https://msdn.microsoft.com/en-us/library/cc645937.aspx

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

Search




Leave an answer