November 26, 2010 at 4:48 am
Hi All,
I have heard a weird statement in one of the training sessions for Sql server 2005 that SP3 degrades the performance for certain queries. After cross questioning and reasoning with the trainer, I didn't get my doubt cleared. Now, I need to upgrade my Sql server 2000 to Sql server 2005...
Can you suggest evidently that SP3 doesn't degrades the performance, as if i go with upgradation, it about a huge production database.
November 26, 2010 at 6:19 am
There is no doubt that in *some* circumstances , that 2005 is slower than 2000.
Now that is not to say that the queries in question cannot be rewritten to execute just as well , and if not better.
The only way you will find out if you are affected is to try the upgrade on a test server and push through a 'reasonable' work load.
November 26, 2010 at 6:46 am
I am not aware of any such issues. All the production instances in my environment are running on SP3 +
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 26, 2010 at 10:52 pm
thanks Dave and Pradeep 🙂
November 27, 2010 at 5:40 am
What you might be seeing is termed a regression by the optimizer team. They fight those tooth & nail, but sometimes they occur. Usually, but not always, you're doing something in the TSQL in 2000 that you probably shouldn't do anyway, but 2005 (& 2008) are less forgiving sometimes for questionable TSQL. At least that's what I've seen most of the time.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply