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 call.it 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
http://www.sql-server-performance.com/stored_procedures.asp
http://www.sql-server-performance.com/cursors.asp

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=’

‘ />] 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=’

‘ />] – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Ich unterstÃ¼tze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)

]]>