Posted by JoeyD on 01/23/07 16:22

Hi 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:
> 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]