January 30, 2014 at 7:04 am
Hi all,
Just wonder if there is a posibillity to trace all user actions which is done on a database ??
There's a need to trace every action such as;
** how many times this user has logged in (and at what time and from which IP/PC),
** which SP has been executed by this user,
** what DML/DDL is processed on which table(s)/objects and how many times,
** etc etc
Who can help me out on this???
Regards, Guus
January 30, 2014 at 7:09 am
Extended events or SQL Trace can both do that. Be aware you're going to have a HUGE amount of data to deal with, store and process.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 30, 2014 at 10:26 pm
In addition resource of the server too may be affected i.e. CPU, MEMORY, I/O etc.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 30, 2014 at 11:03 pm
free_mascot (1/30/2014)
In addition resource of the server too may be affected i.e. CPU, MEMORY, I/O etc.
Extended events are pretty light-weight. Trace, providing it's a server-side trace shouldn't be too bad, but to do all of that it'll be heavier than I prefer.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply