sql time out error

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi all,

I have a asp scripts which runs a stored procedure which runs for about
30 seconds to generate a dataset using ODBC Drivers. Somehow this page
generates the time-out error. To find out what is wrong with page, I
used SQL Profiler to monitor on when the request hits the database and
discovered that it takes about 10 mins before the request shows up.. A
lot of other requests from various scripts appear and then by the time
my script generates the time-out error, SQL Profiler shows the request.
How to fix it? Is there any way of telling the sql server to put a
priority on this query first?

The following is the details of the request that SQL Profiler shows up

eventclass : SQL:BatchCompleted
Textdata: exec myscript blah blah
Application Name: Microsoft¢ç Windows¢ç Operating System
NT username:
LoginName : my login name
CPU : 157875
Duration :6128

Any idea will be fantastic!!!

Thanks


*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • sql time out error
    ... I have a asp scripts which runs a stored procedure which runs for about ... To find out what is wrong with page, I used SQL Profiler ... takes about 10 mins before the request shows up.. ... generates the time-out error, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: sql time out error
    ... If you run the SP from query analyzer, ... > I have a asp scripts which runs a stored procedure which runs for about ... To find out what is wrong with page, I used SQL Profiler ... > takes about 10 mins before the request shows up.. ...
    (microsoft.public.dotnet.languages.csharp)
  • Summary:: Update: mount directory mount point
    ... scripts, but still requested my workaround in the interem. ... > Below was my original request. ... > as its own mount point. ... > Operating Systems Analyst for unix systems ...
    (Tru64-UNIX-Managers)
  • Re: include/require cached and fopen is not?
    ... Jerry Stuckle;105173 Wrote: ... It will be done on every page request. ... Are you saying that the included scripts are revalidated every ...
    (comp.lang.php)
  • Re: How to Add Script stream to WM File, Please HELP
    ... >First of all thanks for responding to my request. ... I am not sure how I can insert scripts while re-encoding the file as ... >request to insert script command for a particular timestamp, encoder is able ... I'm not clear that the WMEncoder object has the same property. ...
    (microsoft.public.windowsmedia.sdk)