sp_prepare?

Alex_Chow

Hi,

While running the SQL Profiler trace, I see a lot of delays in the sp_execute command when we ran through a sales order.

Doing a quick search on Google, I found that sp_execute is ran after sp_prepare is done (where the SQL code is). However, searching through the trace log, I don't find any sp_prepare?

Is there an easy way to find out the SQL code for the sp_execute?

ara3n

Hello Alex
You need to start Sql profiler, Create a new template. Base it of the tunning template.

On the Event Selection, right click on Stored Procedure and Select Event Category.

Check RPC:Starting Event

This even will show the preparation of the statement.


It will look something like below.

declare @p1 int
set @p1=-1
exec sp_prepexec @p1 output,N'@P1 varchar(10)',N'SELECT  * FROM "Navision-5"."dbo"."KRONUS5$Unit of Measure" WITH (READUNCOMMITTED)  WHERE "Code"=@P1  ','TADA'
select @p1

Alex_Chow

Thank you Ahmed, you've been more than helpful.

I turned on the T-SQL in the event view in order to see the SQL script.

Waldo

Other events you might like are:

SP:StmtCompleted
SQL:BatchCompleted

<edit>

When I think of it ... they are also included in the default "tuning" template :-k .