title: Is Change Data Capture Performance Loss Restricted to CDC Enabled Tables?
body: <p>I have read that enabling Change Data Capture obviously has an impact on database performance.
  Would this performance loss only effect the tables that have CDC enabled or would it effect all actions across the database</p>
  
  <p>In my situation I am using SSIS and have a large amount of data moving into and out of a staging database. I also have some lookup tables in the system that are used for transforms. I am hoping to use CDC as a means to audit changes to these reference tables only (not the imported data). The major queries I run as part of the ETL access these reference tables but don't change them so I am trying to figure out if there will still be a noticeable performance hit?</p>
  
  <p>Thanks</p>