Ok, this is the way I am implementing auditing : SCHEMA LEVEL AUDITING

CREATE DATABASE AUDIT SPECIFICATION Example2

FOR SERVER AUDIT ADEVNTUREWORKSAudit

ADD (INSERT,UPDATE,DELETE,SELECT

ON SCHEMA::dbo

BY public)

WITH (STATE = ON)

GO

By, implementing this do I get any performance issues? My database is size is 30 GB..and has harddrive capacity of 200 GB.