SQL Server 2008R2 Auditing or monitoring to track DBA activity on server

• Sachin Butala-182900

  SSC-Addicted

  Points: 406

  More actions

  July 23, 2012 at 11:42 pm

  #392812

  Hi,

  we want to implement solution to track DBA activity on SQL server 2008R2, activity's like:

  1. Accessing DATA (SELECT/INSERT/UPDATE/DELETE)

  2. Generating BACKUP

  or anything they are doing on Database i.e creating users

  we started sql traces/profiles is there other better and efficient way to monitor/ log these activity, which will not kill server performance.

  Regards

  Sachin

• DBA328

  Hall of Fame

  Points: 3952

  More actions

  July 24, 2012 at 3:16 am

  #1516669

  you can try Database Audit Specification and Server Audit Specification.