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
>

Database performance very slow

Hello all,
I have setup a new Database Server (P4, 1G RAM, RAID 1), but i feel the
performance is no good at all..
how can I tune the performance better and make all connections faster'
Basically, i have 1G Ram, and it only have 130MB RAM available from
"Performance Monitor" as it should have 7XXMB memory when system started.
I am afraid that the database will more slow after replication of 10
databases are running...
Now, the replication is setup already, but no database will distribute.
Thanks in advanced.Hi
1GB memory is really small nowadays
"beachboy" <stanley@.javacatz.com> wrote in message
news:OYk%23gDRPGHA.3460@.TK2MSFTNGP15.phx.gbl...
> Hello all,
> I have setup a new Database Server (P4, 1G RAM, RAID 1), but i feel the
> performance is no good at all..
> how can I tune the performance better and make all connections faster'
> Basically, i have 1G Ram, and it only have 130MB RAM available from
> "Performance Monitor" as it should have 7XXMB memory when system started.
> I am afraid that the database will more slow after replication of 10
> databases are running...
> Now, the replication is setup already, but no database will distribute.
> Thanks in advanced.
>

Database performance very slow

Hello all,
I have setup a new Database Server (P4, 1G RAM, RAID 1), but i feel the
performance is no good at all..
how can I tune the performance better and make all connections faster?
Basically, i have 1G Ram, and it only have 130MB RAM available from
"Performance Monitor" as it should have 7XXMB memory when system started.
I am afraid that the database will more slow after replication of 10
databases are running...
Now, the replication is setup already, but no database will distribute.
Thanks in advanced.
Hi
1GB memory is really small nowadays
"beachboy" <stanley@.javacatz.com> wrote in message
news:OYk%23gDRPGHA.3460@.TK2MSFTNGP15.phx.gbl...
> Hello all,
> I have setup a new Database Server (P4, 1G RAM, RAID 1), but i feel the
> performance is no good at all..
> how can I tune the performance better and make all connections faster?
> Basically, i have 1G Ram, and it only have 130MB RAM available from
> "Performance Monitor" as it should have 7XXMB memory when system started.
> I am afraid that the database will more slow after replication of 10
> databases are running...
> Now, the replication is setup already, but no database will distribute.
> Thanks in advanced.
>

Database performance very slow

Hello all,
I have setup a new Database Server (P4, 1G RAM, RAID 1), but i feel the
performance is no good at all..
how can I tune the performance better and make all connections faster'
Basically, i have 1G Ram, and it only have 130MB RAM available from
"Performance Monitor" as it should have 7XXMB memory when system started.
I am afraid that the database will more slow after replication of 10
databases are running...
Now, the replication is setup already, but no database will distribute.
Thanks in advanced.Hi
1GB memory is really small nowadays
"beachboy" <stanley@.javacatz.com> wrote in message
news:OYk%23gDRPGHA.3460@.TK2MSFTNGP15.phx.gbl...
> Hello all,
> I have setup a new Database Server (P4, 1G RAM, RAID 1), but i feel the
> performance is no good at all..
> how can I tune the performance better and make all connections faster'
> Basically, i have 1G Ram, and it only have 130MB RAM available from
> "Performance Monitor" as it should have 7XXMB memory when system started.
> I am afraid that the database will more slow after replication of 10
> databases are running...
> Now, the replication is setup already, but no database will distribute.
> Thanks in advanced.
>