What's the best tool avaliable in the market today for the purpose of Auditing SQL Server without adding too much of overhead on the server itself. For the past 1 month I have been evaluating couple of tools and here is my feedback, any input would be greatly appriciated:
1. Entegra by Lumigent: Great tool, but expensive
2. OMNIAudit: Trigger bases audting, which doesn't add any value as it could be written by the DBA itself and will do the same job. Also this tool doesn't work on a table which doesn't have a UNIQUE key defined on them.
3. SQLAUDIT: same as OMNIAudit.