Post reply

stored procedure running slow

  • July 18, 2012 at 11:29 pm

    #264022

    I have a stored procedure that getting time out when executed on production server, but very fast (about 5 secs only) on development notebook.

    its a sql server 2008 r2, has about 1500records to loop using cursor, do some update tables. a simple stored proc.

    I did a backup data from server, restored on my notebook (which has express edition), the sp runs well in just a few seconds.

    What should I check then? I guess it must be something on sql server itself (or windows server), the server is new installed (standard edition), they were using express edition before decided to buy standard edition/

    thank you.

  • July 18, 2012 at 11:36 pm

    #1514603

    How does the hardware (memory, cpu, 64bit v 32bit, hard disk speed and type), compare between the two?

    Have you examined the execution plan from both machines and checked for differences?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • July 18, 2012 at 11:53 pm

    #1514615

    the server computer should be much superior that my notebook, but thanks for advice, will check about this.

    about the execution plan, I dont think that was the problem, i have the same data (just restored data from production) and it runs well

  • July 18, 2012 at 11:57 pm

    #1514619

    Any chance of getting us the execution plan from both of the servers.

  • July 19, 2012 at 12:19 am

    #1514626

    I'll post them later, im not on my desk at the moment.

    thank you very much for helping.

  • July 19, 2012 at 1:01 am

    #1514639

    here are the execution plan from server and local notebook..

    thanks

Viewing 6 posts - 1 through 5 (of 5 total)

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