Re: stored proc suddenly extremely slow

Jeremy wrote:

I have a D7 app that has been operating successfully for some time.
Starting sometime today, the sp seems to be either running slower by
orders of magnitude (it doesn't time out though).

Here are some facts:
- I've tried the sp in D7 ide, from a tadodataset, and at runtime
from a tadostoredproc. Seemingly locked up both ways (we haven't
tried letting it run more than about 20 minutes, however).

- I can run the stored proc from query analyser both as a sp, and as
sql code. It completes and returns about 20K records in 1-4 seconds.

- When the sp is running from the D7 app, it does not seem to time
out. I guess it's getting records back from the server, even though
glacially.

- When the sp is running from the D7 app, running it from enterprise
manager is much slower than normal, but if I terminate it, EM shows
records returned (a couple of thousand per minute, roughly).

The only thing we can think of that has changed lately is that we've
had problems with our domain controller, and it has been up and down
for days (and no backup dc).

Any ideas where to begin looking?

some questions:

- does it run fine when executing from the same computer? or only when
executing from a remote computer?

- if executing from remote, had you any change in your firewalls
recently?

- any change in MDAC on the development machine? Have you used the MDAC
component checker? See

http://msdn.microsoft.com/data/ref/mdac/downloads/

and

http://www.macropool.com/en/download/mdac_xp_sp2.html

- if it runs on remote, have you checked that there is no app that uses
the same port for communication at the same time?

Btw, which RDBMS are we talking about? Knowing it could perhaps give
more clues.
--
Best regards :)

Guillem Vicens Meier
Dep. Informatica Green Service S.A.
www.clubgreenoasis.com
--
Contribute to the Indy Docs project: http://docs.indyproject.org
--
In order to contact me remove the -nospam

.

Relevant Pages