SQL Server Performance

SQL Profiler Trace

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by gujsa01, Mar 21, 2008.

  1. gujsa01 New Member

    Hi,
    I'm having difficulty relating the trace TEXTDATA values to the corresponding SQL. Our vendor app runs quite a bit of prepared statements. In trace captured I found the following:
    RPC:Completed exec sp_execute 38, 7118179, 501, NULL, 'Apr 3 2008 12:00:00:000AM', 21, 0.000000, 95968.000000, NULL, 0
    RPC:Completed exec sp_execute 1
    I ran this trace for 10 mins but nowhere I could find the associated query to this Plan handle as per RPC Completed event mentioned above. I have seen this quite often but have no answers on this. Appreciate anyhelp with tips to trace the related query..
    Thanks
    gujsa01, Mar 21, 2008
    #2

  2. ndinakar Member

    capture the SP:Completed events too...
    ndinakar, Mar 21, 2008
    #3

  3. Luis Martin Moderator

    Do you know in what language was the application written?
    Luis Martin, Mar 22, 2008
    #4

  4. gujsa01 New Member

    Application is written in Java.
    Will trap the SP:Completed event. Thanks!!
    gujsa01, Mar 23, 2008
    #5

Share This Page