Ok, this is the way I am implementing auditing : SCHEMA LEVEL AUDITING
CREATE DATABASE AUDIT SPECIFICATION Example2
FOR SERVER AUDIT ADEVNTUREWORKSAudit
WITH (STATE = ON)
By, implementing this do I get any performance issues? My database is size is 30 GB..and has harddrive capacity of 200 GB.