 | |
SQL queries are slow in SQL Server 2005 when compared with SQL Server 2000
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
SQL queries are slow in SQL Server 2005 when compared with SQL Server 2000 -
04-24-2008
, 08:36 AM
#2
| |||
| |||
|
|
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 to 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
| |||
| |||
|
|
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 to 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 |
#4
| |||
| |||
|
|
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 to 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 |
#5
| |||
| |||
|
|
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 to 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 |
#6
| |||
| |||
|
|
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 to 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 |
#7
| |||
| |||
|
|
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 to 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 |
#8
| |||
| |||
|
|
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 to 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 |
#9
| |||
| |||
|
|
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 to 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 |
#10
| |||
| |||
|
|
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 to 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 |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.