Database running slow

To all,
I am running SQL Server 2000 SP3 and I have 6 database running on one
machine, in one instance, which has 4GB of ram. All the database are running
fine, except for one. The users are complaining of slowness and query
timeouts. The network traffic is fine and I am not sure what else it could
be. I have also noticed that one of the connections had a waittype called
'CXPACKET'
Does anyone know what could be causing the problem?
Thanks in advance,
BelindaCan you post the query this happens on? How many CPU does the server has and
speed? How are the disks set-up?
CXPACKET It means that one thread of the query is is waiting for a message
packet from another, and the one it is waiting on is either blocked by a
traditional cause or has hit some sort of parallelism bug.
Try Using MAXDOP(1) option on your queries, else make sure you have the
latest service packs applied.
Yovan Fernandez
"Belinda Rodriguez" <rodrigub@.symbol.com> wrote in message
news:e$971JxdDHA.3332@.TK2MSFTNGP09.phx.gbl...
> To all,
> I am running SQL Server 2000 SP3 and I have 6 database running on one
> machine, in one instance, which has 4GB of ram. All the database are
running
> fine, except for one. The users are complaining of slowness and query
> timeouts. The network traffic is fine and I am not sure what else it
could
> be. I have also noticed that one of the connections had a waittype called
> 'CXPACKET'
> Does anyone know what could be causing the problem?
> Thanks in advance,
> Belinda
>