Post reply

Query very slow

  • April 19, 2014 at 4:06 am

    #148531

    Hi All,

    one of my production server i am facing following problem.

    1) stored procedures very slow some time.i mean the same stored procedure morning time i got a result very fast. same parameter some time very very slow.Database engine tuning adviser tool also recommended zero percent.Log file size also very less .tempdb size also less.Please help what may be a reason .what is the solution?

    2) i configured rebuild index job also every alternative days night time.

  • April 19, 2014 at 4:38 am

    #1707243

    There can be tons of reasons...

    Without seeing the code together with the actual execution plan of the code section in question for both cases (fast and slow) it'll be just guessing.

    My pot shot would be a locking/blocking condition or bad statistics.


    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]

  • December 17, 2014 at 4:17 am

    #1765117

    Can we have a look at the logic?

    With Thanks,

    Satnam

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

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