SQL Server Performance Forum – Threads Archive
SQL 7 and SQL 2000
I was working with 2 customers database. (Differents customers)At office I have one server with two instances, SQL 7 SP4 and SQL 2000 SP3, Windows 2000 server.
I restore same database in two instances.
When I run Execution Plan for both, they have same plan to same query.
When I run query, same results.
Diferents are: SQL 7, reads = 6500000, SQL 2000 reads = 27000. (Profiler information)
Of course diferents execution times too.
Is not one particular query, there a lot with same results.
I run Index Defrag, Update Statistics and all what you are thinking. I recommend to my customer to migrate to SQL 2000. I put this post in this Forum, because I believe is relevant when we are looking for performance problems. Brad, feel free to move it. Luis Martin
Moderator
SQL-Server-Performance.com
I presume you might have come accross this linkhttp://www.sql-server-performance.com/query_execution_plan_analysis.asp but still I think this can help. You can move the post by editing your post. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
May be reindexing the table help. If the data is highly fragmented in the SQL 7 scenario, you may observe high logical reads. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
Gaurav:
All maintenance jobs you can image was done.
Is not one query or one table only, I find severals query and sp with same problem.
I think the solutions is easy, SQL2000 works better than SQL 7 in some cases.
Luis Martin
Moderator
SQL-Server-Performance.com
Yes, deploying latest version will definetly have advantage on the terms what you’re looking for. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
The query optizer between 7.0 and 2000 are different and may account for some of this difference, but only scientific testing would be able to tell for sure if this is the culprit. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com
Well, my University Title said "Scientific Computer (Computador CientÃfico)[<img src=’/community/emoticons/emotion-6.gif’ alt=’
‘ />]". Personally I don’t like, but it was the first University Title (about Computers) in Argentina.<br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com
]]>