Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

AutoStart SQL Profiler

Posted on 2008-10-16
1
Medium Priority
?
598 Views
Last Modified: 2008-11-07
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
Comment
Question by:coolrod_de
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 60

Accepted Solution

by:
chapmandew earned 375 total points
ID: 22730629
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

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question