Configuring Trace Operations
-
Hi All,
I want to be able to monitor all queries executed on the database and also anyone who logs onto the databases, but I know I can use profiler, but is there a way that this can run in the backgroud without using profiler, as my fear is that someone can simply stop profiler and my monitoring will be compromised.
Perhaps a stored procedure etc. that i can schedule as a job.
Thanks in advance
-
You can set up a trace with the system stored procs. You then tell that trace to run untill 23:59:59.997 PM. Then you set up a job that runs the trace and you set it to execute at midnight everyday
.Check out the system procs sp_trace_* in BOL. You'll have to dig it up on your own... I'm no expert on that matter.
-
... I forgot to say that this is something that can take quite a bit of resources on the server. So I would really use this on a very unbusy server. Or to monitor SOMEONE I suspect of.?!?.
This can be good too to see what queries are running too slow on the server.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply