468,783 Members | 1,645 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,783 developers. It's quick & easy.

sql profiler trace file

im trying to understand how the profiler works. so i started 2
profilers,one listen to another and I saw the profiler is running:
exec sp_trace_create @P1 output, 1, NULL, NULL, NULL
which means @tracefile = NULL
so where from the profiler read the results?!

Jun 26 '07 #1
1 2986
Profiler essentially creates a SQL Trace and streams the trace data back to
the Profiler client GUI. It is recommended that you use SQL Trace scripts
instead of Profiler on an active system due to the overhead. You can use
Profiler to generate SQL Trace scripts.

--
Hope this helps.

Dan Guzman
SQL Server MVP

<of*****@gmail.comwrote in message
news:11**********************@n60g2000hse.googlegr oups.com...
im trying to understand how the profiler works. so i started 2
profilers,one listen to another and I saw the profiler is running:
exec sp_trace_create @P1 output, 1, NULL, NULL, NULL
which means @tracefile = NULL
so where from the profiler read the results?!
Jun 26 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by jw56578 | last post: by
8 posts views Thread by patrickshroads | last post: by
1 post views Thread by Pushkar | last post: by
8 posts views Thread by Bryan | last post: by
1 post views Thread by Thyagu | last post: by
3 posts views Thread by akkha1234 | last post: by
3 posts views Thread by Sam Samson | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.