Re: About SQL Profiler and query

From: Greg Linwood (g_linwoodQhotmail.com)
Date: 09/20/04 

Date: Mon, 20 Sep 2004 21:39:56 +1000

What are you expecting to see in the TextData column for the SQLTransaction
event? It's documented behaviour is to display "The savepoint or rollback
name, if provided.", according to SQL Server Books Online:
http://msdn.microsoft.com/library/en-us/adminsql/ad_mon_perf_79tf.asp

Given that it's not common to name savepoints or rollbacks, it's probably a
little unusual to expect to see much in SQLTransaction:TextData. Perhaps you
should be profiling a different event - if you post back with what you're
hoping to see, we can perhaps help by recommending a different event to
profile?

Regards,
Greg Linwood
SQL Server MVP

<io.com> wrote in message news:eu8ETkNnEHA.2764@TK2MSFTNGP10.phx.gbl...
> Hi
>
> i have enable SQL Profiler for my SQL2000 DB and view a "SQLTransaction"
> but
> the TextData is always empty and my application name is JSQL.
> This transaction duration is : 10516
>
> The question are :
>
> 1- It's a normal that the "textdata" is always empty ?
> 2- The application name "JSQL" maybe JBOSS on my Apache server?
> 3- The duration of this transaction is too much ?
>
>
> Thanks.
>
>

Relevant Pages