Hi, I have scripted out a trace file which I want to use in a batch file. The functionality needed is to run the batch file to start the trace and the trace should end after running for a couple of minutes. Any Ideas??
Hey Sagar, Here is a link for the script I use for a timed trace. You can modify to stop time to capture the time period you need. In addtion to editing the event classes and columns you want to monitor you might want to exclude the filter on the specific database. Let me know if you have any questions. [T-SQL Code for Timed Profiler Trace] :