Hi,

My sp having more than 5000 lines and it is taking five hours to execute sp. I spitted into four different sp and make it as one single sp.Again I executed my sp, the execution time is same.

In that sp Im not used cursors, temporary tables. I used only drop table, create table, insert, update, truncate and joins. Im using sql server 2014.

How can I reduce my sp execution time from five hours to minutes??

Are there any new features available in sql server 2014 particularly to increase performance of Sp?

Can anyone please suggest me?

How can I increase my sp performance?

 

Thank you

 

Regards,

Yosuva. J

Hello Yosuva,

Please check the execution plan of the SP / single statements to see if suitable indexes are used by the queries,

I agree with Olaf, turn on Profiler or Extended Event to see a SQL  statement  within a stored procedure takes longer ...