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??
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.
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.