Stored Procedure Performance Tuning | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Stored Procedure Performance Tuning

Hi, I am having one SP which contain calls five cursor and around 15 SP as recursive is taking lots of time. I need to debug why it is taking lots of time. Is there any way around by which you can tune sp performance. Please provide your inputs. Thanks and Regards Ravi K
Why do you use Cursors?
The thing that can be done with Cursor can also be done without it
Post the full code you used Madhivanan Failing to plan is Planning to fail
Check these
Pretty interesting construct there you have. 5 cursors, 15 recursive SP’s. Counterquestion: How would you ever expect good performance from this? [<img src=’/community/emoticons/emotion-5.gif’ alt=’;)‘ />]<br />Maybe you should start by providing more informations so we can help. At the moment my crystal ball is quite dark. [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />–<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=></a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=></a>) <br />