Post reply

stored procedure

  • August 7, 2008 at 2:34 am

    #77063

    WHICH STEPS OF IMPROVING POOR PERFORMANCE IN STORE PROCEDURE FOR SQL SERVER 2000?

  • August 7, 2008 at 3:25 am

    #854296

    Please don't post in all capitals. It's the online equivalent of shouting at someone.

    First thing is to find out why the procedure is slow. Are there cursors, while loops or other forms of row-based processing? Run the procedure with STATISTICS TIME and STATISTICS IO on, and look for the parts that take long or have lots of IOs

    Once you've found the parts that take long, you can look at fixing them. That may involve changing cursors to set-based code. If may involve rewriting queries to make them more efficient, it may involve looking at the execution plans and adding or changing indexes.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply