Skip to Content

is there PlanView like tool for Stored Procedure

BEGIN
DECLARE VAR NVARCHAR(7);
VAR = '201507'
VAR = LEFT(:VAR,4)||'0'||RIGHT(:VAR,2);
END

Does the above code cause a cyclic dependency

or is below code - a better way for performance / paralellization

BEGIN
DECLARE VAR NVARCHAR(7);
VAR = '201507'
V_VAR = LEFT(:VAR,4)||'0'||RIGHT(:VAR,2);
END

Finally what is a tool or way to check for performance of Stored Procedures . The Planview option does not work for Stored Procedures

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Feb 12, 2017 at 12:25 PM

    Why the first code should get into a cylcic dependency? The expressions are evaluated and the result is then assigned to variable var. There will be no cyclic dependency.

    The PlanViz tool can be used for stored procedures too (although for anonymous blocks). You will get information about statement statistics and the plan.

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded