[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 490
  • Last Modified:

Schedule an unattended SQL profiler 2008 Trace

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
crazywolf2010
Asked:
crazywolf2010
1 Solution
 
Eugene ZCommented:
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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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