Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL Profiler trace - TextData field is NULL

1 view
Skip to first unread message

D. Chadda

unread,
Sep 8, 2003, 3:06:24 PM9/8/03
to
I ran the SQL Profiler Trace for a short period of time
while my application was running. On analyzing the trace
output, I notice that there are some records in which the
TextData field is NULL, but these records have the
greatest amount of CPU utilization. So I ran the following
query via SQL Query analyzer -

select * from Trace_Table where textdata is null
order by cpu desc

Partial output is shown below:

RowNumber TextData LoginName Reads Writes CPU
746 NULL charlie 10063 12 601
6499 NULL charlie 102 0 0
6940 NULL charlie 86 0 0

Does anybody know why the TextData field for some records
is displayed as NULL, yet there are 10063 Reads and 12
Writes for that record? How is that possible? I would
expect TextData field to contains the SQL query, but it
does not.

I am using SQLProfilerStandard Template name to generate
the trace.

Thanks in advance for your response.

Deepak Chadda

Kalen Delaney

unread,
Sep 8, 2003, 3:20:31 PM9/8/03
to
Hi Deepak

What are these events? Your partial output did not include that piece of
crucial information. Only SQL queries, stored procs, batches, etc, have text
data.

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com


"D. Chadda" <deepak...@itadv.com> wrote in message
news:3e0701c3763c$4bef86d0$a301...@phx.gbl...

Deepak Chadda

unread,
Sep 8, 2003, 4:24:28 PM9/8/03
to
Hi Kalen,
I had saved the trace information to a Trace Table. The
EventClass field in the Trace_Table has a value of 15 for
records where TextData is NULL.

I noticed that records where TextData contained the SQL
queries, the EventClass is 12.

Where can I find information on what EventClass 12 means?

Thanks for your help!
Deepak

>.
>

Kalen Delaney

unread,
Sep 8, 2003, 4:39:50 PM9/8/03
to
15 is a logout event. Look in Books Online for sp_trace_setevent.

The performance data, including CPU, for a logout event, is the total used
by the connection during its entire lifespan. I'm not surprised that's where
you're finding your biggest numbers.

Please read the Books Online sectiosn on the Profiler. It will tell you
which data columns are populated for which events.

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com


"Deepak Chadda" <deepak...@itadv.com> wrote in message
news:454601c37647$34252130$a001...@phx.gbl...

Deepak Chadda

unread,
Sep 8, 2003, 5:07:29 PM9/8/03
to
Kalen,
Thanks for your help!

Deepak Chadda

>.
>

0 new messages