469,917 Members | 1,766 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Need details on Query Profiler

Where is the information coming from that is displayed in query
profiler.
Is it the command that is retrieved before it is processed, or is it
what is actually processed.

Jul 23 '05 #1
3 1399
(jw*****@gmail.com) writes:
Where is the information coming from that is displayed in query
profiler.
Is it the command that is retrieved before it is processed, or is it
what is actually processed.


I'm not sure that I understand the question. Can you be more specific in
which information you are talking about? Is the results of queries
you are talking about?
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2
Not the results of queries, but the acutal command that is executed to
retrieve the results. Isn't that what profiler does, displays all
commands that are being executed on the sql server.
Erland Sommarskog wrote:
(jw*****@gmail.com) writes:
Where is the information coming from that is displayed in query
profiler.
Is it the command that is retrieved before it is processed, or is it what is actually processed.
I'm not sure that I understand the question. Can you be more specific

in which information you are talking about? Is the results of queries
you are talking about?
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp


Jul 23 '05 #3
(jw*****@gmail.com) writes:
Not the results of queries, but the acutal command that is executed to
retrieve the results. Isn't that what profiler does, displays all
commands that are being executed on the sql server.


Ah, I read "query analyzer", not "query profiler".

Profiler is an interface to a server side thing called SQL Trace.
The interface of SQL Trace is a bunch of stored procedure called
sp_trace_create etc. In fact, you can set up a trace with these
procedure, and have it running without using Profiler. I have never
tried this myself.

As for the question:
Is it the command that is retrieved before it is processed, or is
it what is actually processed.


Rather both. You can select the events SP:StmtStarting and
SP:StmtCompleted, so you will see both when the statement started
and when it completed - if it completed. There is not always an even
if the statement aborts in error.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Alexandre MELARD | last post: by
6 posts views Thread by Ralph | last post: by
5 posts views Thread by Chris Kennedy | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.