Query is slow sometimes
- From: treschaud33@xxxxxxxxx
- Date: 13 Sep 2006 10:54:19 -0700
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
.
- Follow-Ups:
- Re: Query is slow sometimes
- From: Erland Sommarskog
- Re: Query is slow sometimes
- Prev by Date: Re: SQL Server E-Learning
- Next by Date: Re: Server configuration for MSSQL 2000 and MSSQL 2005
- Previous by thread: stored proc bug with datetime variable
- Next by thread: Re: Query is slow sometimes
- Index(es):
Relevant Pages
|
