The question I recently come accorss on SQL Server Performance, the OP was asking on "How to automate profiler trace" , their are system stroed procedure that can be used to automate profiler trace. The system stored procedure you can use are sp_trace_create,sp_trace_generateevent,sp_trace_setevent,sp_trace_setfilter and sp_trace_setstatus. Here is complete procedure described on "How to automate profiler trace" , refer http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
Here is a link on "How to monitor trace on SQL Server 2005" http://support.microsoft.com/kb/912914/en-us
9/10/2007
Automate Profiler Trace
12:51 PM
automate profiler trace, monitoring trace, MS Sql server, profiler, sql server 2005
No comments
0 comments:
Post a Comment
I appreciate your time, thanks for posting your comment. I will review and reply to your comment as soon as I can.
Thank you
Hemantgiri