To know all sql ran on database between time t1 and t2
Hi all,
A quick question. What are different ways to have list of all the sql (select/insert/update/delete) which ran on the database in a time range from t1 to t2. Idea is run a GUI screen and see what are the commands being fired on the database (any performance stats along with it be a bonus).
Logminer could be one way, but I am trying to find some views/queries or traces enabling to get this data. Ideas?
thanks in advance.
Logminer could be one way, but I am trying to find some views/queries or traces enabling to get this data. Ideas?
thanks in advance.
0