Solved

Schedule an unattended SQL profiler 2008 Trace

Posted on 2012-03-20
1
433 Views
Last Modified: 2012-08-14
Hi,
I need to trace server performance. I wish to enable an unattended trace at night.
The trace should start at say 10pm and must end by 2 am.

I won't get many attempts to do this. I have seen  methods on google and wish to know the one you have used and worked under SQL 2008.

Thanks
0
Comment
Question by:crazywolf2010
1 Comment
 
LVL 42

Accepted Solution

by:
EugeneZ earned 500 total points
ID: 37745526
use sp_trace_create proc
and the below article instructions

How to Build a Profile Script to Monitor SQL Server off Hours

By Gregory A. Larsen
http://www.databasejournal.com/features/mssql/article.php/3707326/How-to-Build-a-Profile-Script-to-Monitor-SQL-Server-off-Hours.htm
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server R2 Stored procedure performance 8 42
Usage Scenarios for Extended Events? 1 25
Square brackets 4 38
Using CTE to insert records into a table 2 26
     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

932 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now