• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 606
  • Last Modified:

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?
0
coolrod_de
Asked:
coolrod_de
1 Solution
 
chapmandewCommented:
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

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now