Posted by Paul on 01/23/07 10:05

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

[Back to original message]