November 30, 2011 at 5:20 am
Hi folks,
As a DBA, i might be asking a silly question but i'd like to clarify from experts like you.
does sp3 gives better performance than sp2 in sql server 2005?
we are having a big database servers which is having so many sp's and Tables and long ago we applied sp2 and recent days we are getting performance problems.
so, if i apply sp3 to that Instance, will it gives better performance.
TIA..
November 30, 2011 at 5:24 am
SPs and version changes usually mean changes in the query optimiser. So means just that. Could be better, could be worse.
Usually people only complain about the worse part of the equation.
Here's how to find the problem queries =>
November 30, 2011 at 7:27 am
Any increase in performance from one SP to the next is most likely to be extremely marginal. If you're hitting performance issues, you need to do the hard work of identifying where they are, what their cause is, and how to fix it. Gails articles are a good starting point.
"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
November 30, 2011 at 7:37 am
As a side note, SP4 will clear out many bugs, some of them might help with performance.
When in doubt, latest SP is a good default option. As usual, it depents...
Also SP4 is the latest supported version of sql 2005 (assuming it's not cycled out atm).
November 30, 2011 at 10:55 am
Same goes with plugging in the Cumulative Updates after you get to the latest service pack. If you don't know what's causing your slow down, you might see a fix from these things, but you're not going to know for sure. Also, there's a little known trick about the optimizer that could make improvements from an SP or a CU even better (or completely break your code). There's a traceflag[/url], 4199, that will enable even the possibly breaking changes for the optimizer. Worth trying out, but notice I've said "break" twice.
"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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply