Does ApexSQL Log have a large performance overhead?
No, it doesn’t. ApexSQL Log has no performance overhead during audit trail capture since it is not involved in it at all. The application simply reads the transaction logs to gather audit data. This allows auditing to be performed during low load times or even be offloaded to another server. Additional login information (NT user name, application name, and client host name), which is not available from the transaction log of SQL Server, is the only information that is actively captured. This capturing process is done by the ApexSQL Log Connection Monitor which has a minimal overhead. SQL2005 and SQL2008 database transaction logs contain NT user’s SID information, from which a full user name can be extracted. If application name and client host name are not necessary, ApexSQL Log Connection Monitor can be stopped and disabled.