April 16, 2008 at 10:04 pm
There are a few posts complaining about performance issue after the migration. In general SQL2005 is faster than SQL2000. However, there are few queries run much much longer than SQL2000 unexpectedly. DBA may face the situation to rollback to SQL2000 just for one or two queries. I know how frustrated it is.
This makes me think what kinds of query would make the trouble? My post here is to collect as many problems as possible to be aware of. If anyone has any related problem, fix, or any good suggestion would like to share, please add it on.
Maybe there is a site or forum has this kind of discussions already. Does anyone know?
Here are the 2 links to start with:
http://www.developersdex.com/sql/message.asp?p=581&r=6190553
http://www.sql-server-performance.com/articles/per/temp_tables_vs_variables_p1.aspx
“Be careful with migrating to SQL 2005 when you use complicated logic in your stored procedures. The same code can run 10-100 times slower on SQL server 2005!”
April 18, 2008 at 1:26 pm
No queries to post, but I will add that the query optimizer was so modified between 2000 and 2005 that there were bound to be lots of regressive-performing situations. They are still finding and fixing these situations. The just released this week Cummulative Update 7 contains another such patch. But most queries do indeed run as fast or faster.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
June 3, 2008 at 9:38 pm
TheSQLGuru (4/18/2008)
No queries to post, but I will add that the query optimizer was so modified between 2000 and 2005 that there were bound to be lots of regressive-performing situations. They are still finding and fixing these situations. The just released this week Cummulative Update 7 contains another such patch. But most queries do indeed run as fast or faster.
Thank you TheSQLGuru.
Do you have related links about "the query optimizer was so modified between 2000 and 2005"?
June 3, 2008 at 10:10 pm
Sorry, I do not. I do have some insider knowledge as an MVP, but if I told you that stuff I would have to kill you. 😀
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
June 4, 2008 at 7:32 am
Do you work for FBI? 😉
OK, no asking this question any more to save both you and me.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply