Performance

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sami - 07 May 2006 08:42 GMT

A strange problem,
SQL Enterp. 64bit cluster on a Win2k3 16GB RAM, a query (Select * from)
takes 45 minutes to complete whereas it takes only 11 minutes on a SQL 2000
on a win2k cluster with 8GB RAM :)
meanwhile it takes only 6 minutes to export the entire exact table to
another table in another DB :)
Is something wrong with the 64bit ODBC driver?
Thanx in advance
SAMI

Reply to this Message

Nils Loeber - 07 May 2006 12:18 GMT

How did you migrate the database? What is the configuration of the 64bit
cluster? Is it 2005 or 2000? I have a suspicion that there might be some
indices missing.

Best regards
Nils Loeber

>A strange problem,
> SQL Enterp. 64bit cluster on a Win2k3 16GB RAM, a query (Select * from)
[quoted text clipped - 5 lines]
> Thanx in advance
> SAMI

Reply to this Message

Robert Klemme - 23 May 2006 16:22 GMT

> How did you migrate the database? What is the configuration of the 64bit
> cluster? Is it 2005 or 2000? I have a suspicion that there might be some
> indices missing.

select * from table is highly unlikely to be sped up by additional indexing.

Maybe the 2005 cluster has a worse IO subsystem.

Kind regards

robert

Reply to this Message