Post reply

Weird performance problem

  • April 12, 2004 at 9:20 am

    #359417

    Hello,

    I am a developer and administrator of a web applet front end/sql database.  I have a few pages where every few weeks they will start timing out.  Nothing will have changed to cause this problem.  If I take the script for the stored procedure that the page depends on and run it in query analyzer, the page starts responding normally again.  Does anyone have any idea what could cause this problem?

    Thanks!

    SJ

  • April 13, 2004 at 8:03 am

    #502562

    I would do a profiler trace of the DB activity during the time of occurance. Any number of things could be happening from common locking to more obscure problems like iterative recompilation of your SP due to mangled statistics...

    It's too hard to tell from the limited information provided.

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

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