Running Views on SP2 Slower than SP3

Hi has anybody experienced views running slower on SQL 8 SP2 is slower than
running it on SP3?
I have 1 log shipping report server on SP3 that runs those views with out
problems.
I have another server with Replication running SP2, I find that views runnin
g
on this server has more locks and runs a lot slower. Some reports can't even
finish.
Is there such a big difference in SP3 as it pertains to running Views?
oh btw hardware is the same on both servers.
any help would be greatly appreciated..
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200603/1I have no doubt that SP3 contains fixes for a number of specific query
optimization (and other performance) problems that still existed in SP2.
That really shouldn't come as a surprise. It isn't as simple as SP3 being
better at running "Views", but rather that some set of your Views likely
have a narrow set of circumstances that versions prior to SP3 didn't handle
well.
Is there a reason you don't upgrade the SP2 server to SP3 (or SP4!)? SP2 is
definitely out of date.
Hal Berenson, President
PredictableIT, LLC
http://www.predictableit.com
"sqlclubber via droptable.com" <u19392@.uwe> wrote in message
news:5d11c243b34e5@.uwe...
> Hi has anybody experienced views running slower on SQL 8 SP2 is slower
> than
> running it on SP3?
> I have 1 log shipping report server on SP3 that runs those views with out
> problems.
> I have another server with Replication running SP2, I find that views
> running
> on this server has more locks and runs a lot slower. Some reports can't
> even
> finish.
> Is there such a big difference in SP3 as it pertains to running Views?
> oh btw hardware is the same on both servers.
> any help would be greatly appreciated..
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200603/1