how to START and stop profiler at specific time

[alex]

Hi,

We want trace ALL activity on prod
server between 3:00 AM and 3:15 AM

Profiler has stop time option ,but
no start option.

I am looking for example how it could be done

Thank you

Alex

[MAK]

http://www.databasejournal.com/featu...le.php/1440421

[MAK]

C:\Program Files\Microsoft SQL Server\80\Tools\Binn> profiler.exe /?

You can schedule this using Windows Scheduler or sql Scheduler.

[skhanal]

1. Define the trace in profiler, and save it as trace file for 2000.

2. Open the trace file in query analyzer, add

waitfor time '03:00:00'

in the beginning,

at then end add

waitfor time '03:15:00'

[skhanal]

1. Define the trace in profiler, and save it as trace file for 2000.

2. Open the trace file in query analyzer, add

waitfor time '03:00:00'

in the beginning,

at then end add

waitfor time '03:15:00'

[alex]

thank a lot to everyone for quick help.

I used example provieded by skhanal