Automate SQL Server 2008 profiler?

Question

question

Sagar Bhargava asked Oct 13, '11

Automate SQL Server 2008 profiler?

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??

profiler

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2011-10-13T02:49:04Z

Kev Riley answered Oct 13, '11

Christina Leo presented something along these lines at SQLBits9. Slides and demos available at

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2011-10-17T12:54:30Z

Christina Leo answered Oct 17, '11

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][1] [1]: http://bit.ly/TimeTraceScript

3

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley ♦♦ commented · Oct 17, 2011 at 12:55 PM

+1 thanks for stopping by. Great presentation by the way!

2 ·

Christina Leo commented · Oct 17, 2011 at 01:06 PM

Thanks Kev! Hoping to get another chance to present at SQLBits 10.

0 ·

Mrs_Fatherjack commented · Oct 18, 2011 at 03:21 AM

Hope you manage to get there,it would be great to see you again.

0 ·

question