Loading

Complexity of SQL server stored procedure

rupal

14y2.1kSQL

Hi,

Thanks for reading this post.

We have a requirement where we need to identify the complexity of the SQL server stored procedure based on the parameters such as, no. of multiple joins,no. of inline sp calls,no. of if/else constructs etc.

Is there any tool that can be used to analyze the SP based on the above parameters? Any help regarding this would be highly appreciated.

Thanks in advance.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Senthilkumar14y ago
I do not think, we have any such tools to analyse the complexity of the stored procedure. But sql server gives the inbuilt view to get the execution estimation. We can use the sql server estimated plan to get the query which takes more time.Based on that we can fine tune that.