none
performance tuning of stored procedures

    Question

  • How do i do performance tuning of stored procedures?
    I was browsing the internet and found this link, http://www.sql-server-performance.com/tips/stored_procedures_p1.aspx

    but is there any other way like a step by step procedure that i need to follow in order to fine tune the procs?

    I heard that we can use sql profiler and database engine tuning advisor, but i don't know how to use those tools for performance tuning of stored procedures?

    Would be eagerly waiting for your replies :)

    Thanks
    Thursday, October 21, 2010 12:45 PM

Answers

All replies