Issue with DB on particular machine

Hi,

I am at a bit of a loss about what to do with a problem I am having. I
have a 7GB database, loaded on to SQL Server 2000 SP4 on 2 different
machines.

Machines have following specs:

1) Intel Pentium 4 Dual Core 3.40 GHz, 3 GB RAM, 2GBb RAM available to
SQL Server. Windows 2003 SP1
2) AMD Athlon 2500 + (1.8GHz), 2GB RAM, , 2GBb RAM available to SQL
Server. Windows 2003 R2 SP1

I hope this is enough relevant information.

The 2nd machine handles the database fine, complex queries are OK etc.
The 1st machine cannot even handle generating an estimated execution
plan for a query on a single table. It dies and has to be killed via
the power button.

However, I have another 9GB DB on the same machine that I can run
complex queries against with no problem.

I thought that there may be a particular issue with that DB so I ran
DBCC CHECKDB against it but no errors were reported. I have also run
Check Disk on the machine and again, no problems were found. So I am
currently at a complete loss about what to do. Both instances of the DB
have come from the same backup. I do not really know what else to try
with this.

If anybody has any ideas at all it would be greatly appreciated.

Thanks in advance,

PaulHi Paul - what are the disk drives like on both servers? Where are the
databases' data files located on each server? If you doing a lot of I/O
(which I suspect your are) then you might want to look at Disk I/O
and/or disk thru put.

JD

Paul wrote:

Quote:

Originally Posted by

Hi,
>
I am at a bit of a loss about what to do with a problem I am having. I
have a 7GB database, loaded on to SQL Server 2000 SP4 on 2 different
machines.
>
Machines have following specs:
>
1) Intel Pentium 4 Dual Core 3.40 GHz, 3 GB RAM, 2GBb RAM available to
SQL Server. Windows 2003 SP1
2) AMD Athlon 2500 + (1.8GHz), 2GB RAM, , 2GBb RAM available to SQL
Server. Windows 2003 R2 SP1
>
I hope this is enough relevant information.
>
The 2nd machine handles the database fine, complex queries are OK etc.
The 1st machine cannot even handle generating an estimated execution
plan for a query on a single table. It dies and has to be killed via
the power button.
>
However, I have another 9GB DB on the same machine that I can run
complex queries against with no problem.
>
I thought that there may be a particular issue with that DB so I ran
DBCC CHECKDB against it but no errors were reported. I have also run
Check Disk on the machine and again, no problems were found. So I am
currently at a complete loss about what to do. Both instances of the DB
have come from the same backup. I do not really know what else to try
with this.
>
If anybody has any ideas at all it would be greatly appreciated.
>
Thanks in advance,
>
Paul