By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,265 Members | 1,343 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,265 IT Pros & Developers. It's quick & easy.

Need details on Query Profiler

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
(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

P: n/a
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

P: n/a
(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.