This project is read-only.

Difference between StandardCDC triggers and Normal Auditing Trigger

Feb 24, 2015 at 10:00 AM
Edited Feb 24, 2015 at 11:56 AM
Just wanna ask a simple question. What is the performance difference here when using StandardCDC approach and normal Auditing Trigger Approach?

I am asking this as I cannot figure out the usage of SQL Agent in StandardCDC which is the main thing in CDC. It seems like this is just another trigger (it might give better performance than usual auditing trigger , but I have to check that as well).
We are not using SQL Agent in this approach at all (correct me if I am wrong).