Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sachinonnet
Starting Member
4 Posts |
 Posted - 2012-07-24 : 01:41:19
|
| 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 BACKUPor anything they are doing on Database i.e creating userswe started sql traces/profiles is there other better and efficient way to monitor/ log these activity, which will not kill server performance.RegardsSachin |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2012-07-24 : 02:00:37
|
| Default Trace is one the best option to trace users activity: http://sqlfrndz.wordpress.com/2011/06/05/default-trace-sql-server-20052008r2/ |
 |
|
|
|
|
|
SQL Server Auditing or monitoring DBA activitys