Why is SQL 2000 running slower than SQL 7 !!!!!!!

[SeanJansson]

We have a query that runs about 25% slower on SQL 2000.

SQL Server 2000 running on Windows 2000 server
versus
SQL Server 7 running on Windows NT 4 workstation

Both installations are on identically specified machines.

The query was doing aggregation and has 'plenty' of group by clauses. Just 1 join across 85,000 records.

Does anybody have hints as to why this could be ? And as importantly how we could remedy this situation.

Thanks for at least reading this.
Sean.

 

[foxdev]

How much data is being returned to the client? If a lot, check that both are using the same client library.

Also, statistics may be more up to date on one vs. the other. Robert Bradley

http://www.foxdev.com/

Got extra money lying around? Visit:

http://www.agrainofhope.org

 

[Guest_imported]

Hi I heard sometime a client who said that with NTFS his server was slower than with FAT32.Are you sure the "both installations are on identically specified machines".
I ever have good news about sql2k

 

[jnicho02]

Sean,
I take it that you've transferred the db by restoring, so the data is in the same physical order. I know that you set up the SQL Server 7.0 server so will have done the 2000 in the same way.

Difficult to say really. Update statistics? NT memory allocation to SQL Server? Query written by Carl? ;-)

Have you looked at the query plan? What is the performance monitor doing? is the tempdb the same size and on a different disk to the data? My home ---->

http://www.geocities.com/jnicho02/

My company ->

http://www.firstlightassociates.co.uk/