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

    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..
  2. ndinakar Member

    capture the SP:Completed events too...
  3. Luis Martin Moderator

    Do you know in what language was the application written?
  4. gujsa01 New Member

    Application is written in Java.
    Will trap the SP:Completed event. Thanks!!

Share This Page