In this scenario agent-less auditing, can provide value. There are many knobs and switches in database platforms’ native auditing capabilities that can be tuned in order to capture specific activity.

Sentrigo Adds Microsoft SQL Server Support to Its Hedgehog Database Activity Monitoring Software Major new release includes module for rapid implementation of PCI DSS, SOX, SAS 70 database compliance ...

The result is database operations teams are facing growing pressure to ensure SQL Server environments are undergoing rigorous security monitoring and measuring against compliance guidelines.

SQL Server Activity Monitor can help you identify locking and blocking issues. Closely watch the Wait Time, Wait Type, Wait Resource and Blocked By values for listed processes.

Despite a few rough edges in the beta version, Entegra does a fairly complete job of auditing SQL Server activity.