Profiler's TextData column has 'NULL' and longest Durations

[Robert]

Is there a way to determine why the Textdata field has "NULL" for a value.
The trace shows multiple "NULL" value records with the longest durations;
many greater than 50,000ms. The {} indicate the TextData and Duration on
the line below:

rownumber | textdata | Eventclass | ......| Duration |...
966 | 15 | {NULL} | 24 smm5413 | 808 | Microsoft Office XP | misview012 | 78
| {604636} | 2004-02-11 15:25:12.010 | 4747 | 0 | 469

[Erland Sommarskog]

Robert (st*******@boeing.com) writes:

Is there a way to determine why the Textdata field has "NULL" for a value.
The trace shows multiple "NULL" value records with the longest durations;
many greater than 50,000ms. The {} indicate the TextData and Duration on
the line below:

rownumber | textdata | Eventclass | ......| Duration |... 966 | 15 |
{NULL} | 24 smm5413 | 808 | Microsoft Office XP | misview012 | 78
| {604636} | 2004-02-11 15:25:12.010 | 4747 | 0 | 469

Yes, there is a away. Read Books Online. :-)

But I have to admit that I don't know where yon find a table which gives
the event given the numeric event-class id, so I had to resort to linear
search.

Anyway, event id 15 is Audit:Logout, and this event class does not
come with any text data.

And if you are looking for performance hogs, this is not your guy anyway.
Being connected for more than 50 seconds is not unusual.

--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

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