AutoStart SQL Profiler

Hi,
Does anybody know how to schedule an SQL Profiler Trace, save to File?
Or how to automatically start a trace when an event occurs such Transactions / Sec > 10?
coolrod_deAsked:
Who is Participating?
 
chapmandewConnect With a Mentor Commented:
Yep.  Here is what you do...create your trace in profiler like you would when you run it by hand.  Export the trace definition to a file.  Take what is in that file and create a stored procedure.  Have SQL server run that stored proc on startup.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.