1. SQL Server 2000 linked tables - slow performance since server transition
2. SQL queries are slow in SQL Server 2005 when compared with SQL Server 2000
Hi,
I have installed SQL2000 and SQL2005 on the same computer accessing the same
DB
When run the following simple queries the performance is as follows
Could some one please advice on how improve the performance on these queries
run on SQL2005
Are there any settings to be done in SQL2005 ?
SELECT Int_Key FROM fDocHst
Records 20422
SQL2000 - Uses an Index scan, reads 30, avg. dur 63
SQL2005 - Uses an Index scan, reads 30, avg. dur 406
SELECT Int_Key, DocumentNo, Sts, Rev, Title, Category, IntApprvd,
AvlDwgFmts, IntAdr, Type
FROM fDocHst
Records 20422
SQL2000 - Uses a Clustered Index scan, reads 2342, avg. dur 700
SQL2005 - Uses a Clustered Index scan, reads 2342, avg. dur 1261
3. Slow performance - SQL Server 2000
4. Slow performance of SQL Server 2000 against 6.5
5. Occasional Very Slow Performance.. with SQL Server 2000
6. Sql Server 2000 slow performance
7. Slow performance in SQL Server 2000
8. SQL Server 2005 Vs SQL Server 2000 Performance Comparison
9. Problema para actualizar SQL Server 6.5 a SQL Server 2000 en Windows 2000 Server
10. Problem upgrade sql server 6.5 to sql server 2000 enterprise edition on Windows 2000 Server
11. Performance Issues - Access 2000 Frontend SQL Server 2000 Backend
12. Performance difference between SQL 6.5 and SQL 2000 server
13. SQL Server 2000 on Windows 2003 server reboot?