|
|
Posted by Erland Sommarskog on 09/13/06 22:04
(treschaud33@yahoo.com) writes:
> 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?
Have you checked for blocking updates? That's the most obvious thing to
look for.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|