Identifying which part of stored procedure is taking long time

[Former Member]

Hi Everyone,

I have a stored procedure which is taking long time to execute.  I am trying to understand which part/query in the stored procedure is taking long time.

It involves lots of table variables and n no of queries .Could anyone please help me in how to identify which query/part of the stored procedure is taking long time to execute?

Thanks in Advance

[vivekbhoj]

Hi,

Did you try running a plan visualization for your procedure?

Regards,

Vivek

[Former Member]

Hi Vivek -

I am only familiar with running the plan visualization for a single SQL query.
Could you please guide me how to run it for a procedure.

Thanks in Advance.

[vivekbhoj]

Hi Manikandan,

Just run the CALL Statement in SQL console and Choose Visualize Plan

Regards,

Vivek