There is some performance loss on the database which is selected for auditing via the Database Content Audit feature.
This is a standard overhead inherent in any change auditing systems. This overhead can only affect the database you have selected for monitoring. It is recommended to enable the Database Content Audit feature for the databases with low load only.
To reduce the SQL Server performance impact, specify the exact databases where you want to track data changes, with exact tables for these databases.