Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Unanswered: Again Timeout errors

    There is this sp which is used in the webpage, it takes 3 seconds to execute from the
    query analyser, but when it is called from the asp page it ends up in
    "Microsoft OLE DB Provider for SQL Server error '80040e31'
    Timeout expired "
    I know it is an General error and there can be many reasons to it,
    but on setting a profiler I found out that the sp is called only when the page timeouts,
    meaning for some time there is no activity say for 5 -8 seconds and after that the sp is called and
    the page timeouts...
    There is no rendering/formatting on the page. what can be the possible cause of it??

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    Whada heck...
    the sp just needed a recompile...
    can anyone explain why?
    no base tables were modified, tables are referenced acrossed two different
    databases, WITH (NOLOCK) query hint is used in the sp.

  3. #3
    Join Date
    Jun 2004
    Location
    Far away from heaven
    Posts
    194
    I've got the same prob. but the asp pages use dynamic SQL rather than SPs. When a user enters credentials into login page and press GO, it takes 3-5 minutes for welcome page to get displayed!!! When i run trance on the server there's no execution (only one query executes and the second comes after several seconds) being made nor there's any processor usage; what the page is spinning and doing. Is the problem with IIS. ???
    Any body had the same experience? How to square this.



    Howdy.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •