October 21, 2010 at 8:31 am
Hello, I run the same two queries, query 1 on 2000 sql it takes 1 minute and 2 on 2005 enviroment takes 3 minutes, I checked for tabels they all the same. What could cause this? The only difference is that 2005 have more databases on the server
October 21, 2010 at 9:35 am
Try comparing the ACTUAL execution plans.
Are they identical?
If not, are there any missing/different indexes?
-- Gianluca Sartori
October 21, 2010 at 10:17 am
We had performance issues after upgrading to 2005. Some of them were resolved after closely looking at the joins and finding we needed to modify or add the CONVERT functions between dissimilar data types. Not sure why, but it seemed as though 2000 was more forgiving of data type differences in joins. Look at some executions plans for areas to tune.
Here's a previous thread on this topic:
http://www.sqlservercentral.com/Forums/Topic809627-149-1.aspx
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply