Post reply

Performance issue by Checkpoint ?

  • August 27, 2011 at 9:29 am

    #390290

    Hello All, I was checking the performance of one big query in two alike environments. While in one environment it took 45 mins to complete in another one, it took almost 120 minutes to complete. I saw lazy writer and checkpoint running in culprit environment. Can that be the reason behind poor performance ? There were no blocking in the database. The database in second server was refreshed from first server only.

  • September 5, 2011 at 12:04 pm

    #1377132

    Both have the same hardware? That includes IO path, Memory, CPU etc.

    Also did you take into account caching of data? Lots of reason why a query can take different time to execute the same stored proc with same data.

    -Roy

  • September 5, 2011 at 1:07 pm

    #1377141

    Wow. 45min and 120min... Sounds like an enormous complex query. Or one that calls desperately for a deep analysis. Can you post some rough figures about this monster?


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

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

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