stored proc suddenly extremely slow
- From: "Jeremy" <jeremy___ninprodata.com>
- Date: Thu, 17 Aug 2006 17:20:17 -0700
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?
.
- Follow-Ups:
- Re: stored proc suddenly extremely slow
- From: Guillem
- Re: stored proc suddenly extremely slow
- Prev by Date: DBGrid problem
- Next by Date: Re: DBGrid problem
- Previous by thread: DBGrid problem
- Next by thread: Re: stored proc suddenly extremely slow
- Index(es):
Relevant Pages
|
