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
  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