|
|
Posted by treschaud33 on 09/13/06 17:54
What might be going on here? The Query is against a single table with
some criteria. The database is active with upto 200 connected users
and at peak times there are 10 or more active sessions. Most of the
time, the query comes back in milliseconds. Occasionally though, it it
can take a whole minute. I've been watching CPU, Memory, Disk. None
of these appear to be the bottlenecking. (CPU usually below 10% and
always below 50%, pages/sec is 0, and disk % is low and does not
spikes during hangs) I also checked to see if hangs were synching with
Tlog backups or other scheduled jobs, but that is not the case. The
box has good hardware 4GB RAM and 2 CPU at 3.4 GHz. What could be
holding this query up?
Thanks for any ideas.
Dave
Navigation:
[Reply to this message]
|