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

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 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/Forums...erver/200603/1
I 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/Forums...erver/200603/1

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 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 SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-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 SQLMonster.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 SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1sql

Running Symantec AntiVirus software on SQL Server 2000 v8.00.194

Is anyone running Symantec (Norton) AntiVirus Corporate v9 on a machine that
has SQL Server 2000 v8.00.194? If so, have you experienced any problems. W
e
are planning to add this antivirus software to our server running eBackOffic
e
Suite Release 7.2 that uses databases stored in SQL Server 2000.
--
Thanks for any assistance you can provide!
--
TammyFirst of all, is there any reason why you are still running on build
194? That's the RTM release of SQL Server 2000 without any service pack,
and more importantly without any security fixes. That itself is a big
risk, exposing the server to virus attack such as slammer.
Yih-Yoon Lee
My blog http://www.mssql-tools.com/blog
E-mail: yihyoon.online@.gmail.com
/* remove .online to send me e-mail */
Tambo wrote:
> Is anyone running Symantec (Norton) AntiVirus Corporate v9 on a machine t
hat
> has SQL Server 2000 v8.00.194? If so, have you experienced any problems.
We
> are planning to add this antivirus software to our server running eBackOff
ice
> Suite Release 7.2 that uses databases stored in SQL Server 2000.|||You'd want to exclude your data and log files. Additionally,
the following article has some guidelines:
INF: Consideration for a Virus Scanner on a Computer That Is
Running SQL Server
http://support.microsoft.com/?kbid=309422
-Sue
On Thu, 20 Jan 2005 11:53:02 -0800, "Tambo"
<Tambo@.discussions.microsoft.com> wrote:

> Is anyone running Symantec (Norton) AntiVirus Corporate v9 on a machine th
at
>has SQL Server 2000 v8.00.194? If so, have you experienced any problems.
We
>are planning to add this antivirus software to our server running eBackOffi
ce
>Suite Release 7.2 that uses databases stored in SQL Server 2000.
>--
>Thanks for any assistance you can provide!|||Tambo wrote:
> Is anyone running Symantec (Norton) AntiVirus Corporate v9 on a
> machine that has SQL Server 2000 v8.00.194? If so, have you
> experienced any problems. We are planning to add this antivirus
> software to our server running eBackOffice Suite Release 7.2 that
> uses databases stored in SQL Server 2000. --
> Thanks for any assistance you can provide!
194 is the "buggy" retail release of SQL Server. You should first
consider updating your server to SP3a.
I personally have not had a problem running NAV Corporate on a SQL 2000
box.
David Gugick
Imceda Software
www.imceda.com|||.194?!?!?!
You need to upgrade to SP3a NOW. DO NOT DELAY! There are still cases of
the slammer worm affecting SQL Servers, the last one in the media was
reported in Australia last week.
I have used NAV Corp on SQL Servers with success, but I always exclude
the SQL Server data and log file directories.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Tambo wrote:
> Is anyone running Symantec (Norton) AntiVirus Corporate v9 on a machine t
hat
> has SQL Server 2000 v8.00.194? If so, have you experienced any problems.
We
> are planning to add this antivirus software to our server running eBackOff
ice
> Suite Release 7.2 that uses databases stored in SQL Server 2000.

Running Symantec AntiVirus software on SQL Server 2000 v8.00.194

Is anyone running Symantec (Norton) AntiVirus Corporate v9 on a machine that
has SQL Server 2000 v8.00.194? If so, have you experienced any problems. We
are planning to add this antivirus software to our server running eBackOffice
Suite Release 7.2 that uses databases stored in SQL Server 2000.
Thanks for any assistance you can provide!
Tammy
First of all, is there any reason why you are still running on build
194? That's the RTM release of SQL Server 2000 without any service pack,
and more importantly without any security fixes. That itself is a big
risk, exposing the server to virus attack such as slammer.
Yih-Yoon Lee
My blog http://www.mssql-tools.com/blog
E-mail: yihyoon.online@.gmail.com
/* remove .online to send me e-mail */
Tambo wrote:
> Is anyone running Symantec (Norton) AntiVirus Corporate v9 on a machine that
> has SQL Server 2000 v8.00.194? If so, have you experienced any problems. We
> are planning to add this antivirus software to our server running eBackOffice
> Suite Release 7.2 that uses databases stored in SQL Server 2000.
|||You'd want to exclude your data and log files. Additionally,
the following article has some guidelines:
INF: Consideration for a Virus Scanner on a Computer That Is
Running SQL Server
http://support.microsoft.com/?kbid=309422
-Sue
On Thu, 20 Jan 2005 11:53:02 -0800, "Tambo"
<Tambo@.discussions.microsoft.com> wrote:

> Is anyone running Symantec (Norton) AntiVirus Corporate v9 on a machine that
>has SQL Server 2000 v8.00.194? If so, have you experienced any problems. We
>are planning to add this antivirus software to our server running eBackOffice
>Suite Release 7.2 that uses databases stored in SQL Server 2000.
>--
>Thanks for any assistance you can provide!
|||Tambo wrote:
> Is anyone running Symantec (Norton) AntiVirus Corporate v9 on a
> machine that has SQL Server 2000 v8.00.194? If so, have you
> experienced any problems. We are planning to add this antivirus
> software to our server running eBackOffice Suite Release 7.2 that
> uses databases stored in SQL Server 2000. --
> Thanks for any assistance you can provide!
194 is the "buggy" retail release of SQL Server. You should first
consider updating your server to SP3a.
I personally have not had a problem running NAV Corporate on a SQL 2000
box.
David Gugick
Imceda Software
www.imceda.com
|||..194?!?!?!
You need to upgrade to SP3a NOW. DO NOT DELAY! There are still cases of
the slammer worm affecting SQL Servers, the last one in the media was
reported in Australia last week.
I have used NAV Corp on SQL Servers with success, but I always exclude
the SQL Server data and log file directories.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Tambo wrote:
> Is anyone running Symantec (Norton) AntiVirus Corporate v9 on a machine that
> has SQL Server 2000 v8.00.194? If so, have you experienced any problems. We
> are planning to add this antivirus software to our server running eBackOffice
> Suite Release 7.2 that uses databases stored in SQL Server 2000.

Running Symantec AntiVirus software on SQL Server 2000 v8.00.194

Is anyone running Symantec (Norton) AntiVirus Corporate v9 on a machine that
has SQL Server 2000 v8.00.194? If so, have you experienced any problems. We
are planning to add this antivirus software to our server running eBackOffice
Suite Release 7.2 that uses databases stored in SQL Server 2000.
--
Thanks for any assistance you can provide!
--
TammyFirst of all, is there any reason why you are still running on build
194? That's the RTM release of SQL Server 2000 without any service pack,
and more importantly without any security fixes. That itself is a big
risk, exposing the server to virus attack such as slammer.
Yih-Yoon Lee
My blog http://www.mssql-tools.com/blog
E-mail: yihyoon.online@.gmail.com
/* remove .online to send me e-mail */
Tambo wrote:
> Is anyone running Symantec (Norton) AntiVirus Corporate v9 on a machine that
> has SQL Server 2000 v8.00.194? If so, have you experienced any problems. We
> are planning to add this antivirus software to our server running eBackOffice
> Suite Release 7.2 that uses databases stored in SQL Server 2000.|||You'd want to exclude your data and log files. Additionally,
the following article has some guidelines:
INF: Consideration for a Virus Scanner on a Computer That Is
Running SQL Server
http://support.microsoft.com/?kbid=309422
-Sue
On Thu, 20 Jan 2005 11:53:02 -0800, "Tambo"
<Tambo@.discussions.microsoft.com> wrote:
> Is anyone running Symantec (Norton) AntiVirus Corporate v9 on a machine that
>has SQL Server 2000 v8.00.194? If so, have you experienced any problems. We
>are planning to add this antivirus software to our server running eBackOffice
>Suite Release 7.2 that uses databases stored in SQL Server 2000.
>--
>Thanks for any assistance you can provide!|||Tambo wrote:
> Is anyone running Symantec (Norton) AntiVirus Corporate v9 on a
> machine that has SQL Server 2000 v8.00.194? If so, have you
> experienced any problems. We are planning to add this antivirus
> software to our server running eBackOffice Suite Release 7.2 that
> uses databases stored in SQL Server 2000. --
> Thanks for any assistance you can provide!
194 is the "buggy" retail release of SQL Server. You should first
consider updating your server to SP3a.
I personally have not had a problem running NAV Corporate on a SQL 2000
box.
David Gugick
Imceda Software
www.imceda.com|||.194?!?!?!
You need to upgrade to SP3a NOW. DO NOT DELAY! There are still cases of
the slammer worm affecting SQL Servers, the last one in the media was
reported in Australia last week.
I have used NAV Corp on SQL Servers with success, but I always exclude
the SQL Server data and log file directories.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Tambo wrote:
> Is anyone running Symantec (Norton) AntiVirus Corporate v9 on a machine that
> has SQL Server 2000 v8.00.194? If so, have you experienced any problems. We
> are planning to add this antivirus software to our server running eBackOffice
> Suite Release 7.2 that uses databases stored in SQL Server 2000.sql