March 23, 2009 at 1:21 am
1. Is it possible to monitor or recieve information of all transactions
made by a user for a specified time, example a day or few hours.
2. Is their any reliable,legal software available for sql monitoring esp
with the above mentioned ques
March 23, 2009 at 3:05 am
You can use SQL Profiler to trace what queries (and more) are happening against a database. You can also add filters to the trace so that only the data you are interested in is recorded. Profiler is found under Performance Tools in the SQL Server group in the Start menu. You can leave the trace running or set an end time. You can also set up tracing within the database itself.
The trace will capture all activity so unless you know how the user application works it may be difficult to translate the captured data into the equivalent actions within an application.
March 23, 2009 at 4:20 am
The best way to do it is run a manual trace. Create a Profiler session with the Login as a filter. Then script out the trace and set it up in a job.
Mind you, as DNA said, the trace will grab everything and only filter after it grabs the stuff. But by running the trace without the Profiler GUI, you will probably get less overhead than if you use the GUI.
Also, don't record all events / columns. Pick what you need and only what you need. That will also help you not to overwhelm your database.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply