Drop Table

Support Forum for database administrators and web based access to important newsgroups related to databases
Register on Database Support Forum Edit your profileCalendarFind other Database Support forum membersFrequently Asked QuestionsSearch this forum -> 
For Database admins: Free Database-related Magazines Now Free shipping to Texas


Post New Thread










Thread
Author

Applying 2003 SP1 to a SQL Cluster running SP3
Are there any known problems applying 2003 SP1 to a 2003 Active/Passive SQL
Cluster running SQL SP3, not 3a?  We have seen enough posts about SQL SP4
issues that we want to wait.

Report this thread to moderator Post Follow-up to this message
Old Post
JGTKD
08-23-05 01:23 AM


RE: Applying 2003 SP1 to a SQL Cluster running SP3
We did just this on Saturday and it has been a nightmare.  Everything was
running fine with Windows 2003 and SQL2000 SP3 but installing W2K3 SP1 has
wreaked havoc!

Our overall performance has dropped dramatically.  What used to take 2
seconds to run now takes upwards of 6.  We've been working with Microsoft an
d
they have absolutely no idea what the problem is and haven't really offered
much in terms of troubleshooting ideas either.

One suggestion we've heard is to update statictics on all tables (which I am
doing right now) but it doesn't seem to make a difference.

Of course Microsoft says that all of this should work fine and that W2K3 SP1
and SQL 2000 SP3 should co-exist fine in a cluster....

Good luck!

"JGTKD" wrote:

> Are there any known problems applying 2003 SP1 to a 2003 Active/Passive SQ
L
> Cluster running SQL SP3, not 3a?  We have seen enough posts about SQL SP4
> issues that we want to wait.

Report this thread to moderator Post Follow-up to this message
Old Post
Drinian
08-23-05 08:23 AM


RE: Applying 2003 SP1 to a SQL Cluster running SP3
Any updates on this thread? I am looking to do the same thing (sp1 on 2003
Enterprise Server running mssql2000 sp3) in the near future.
Thanks.

"Drinian" wrote:

> We did just this on Saturday and it has been a nightmare.  Everything was
> running fine with Windows 2003 and SQL2000 SP3 but installing W2K3 SP1 has
> wreaked havoc!
>
> Our overall performance has dropped dramatically.  What used to take 2
> seconds to run now takes upwards of 6.  We've been working with Microsoft 
and
> they have absolutely no idea what the problem is and haven't really offere
d
> much in terms of troubleshooting ideas either.
>
> One suggestion we've heard is to update statictics on all tables (which I 
am
> doing right now) but it doesn't seem to make a difference.
>
> Of course Microsoft says that all of this should work fine and that W2K3 S
P1
> and SQL 2000 SP3 should co-exist fine in a cluster....
>
> Good luck!
>
> "JGTKD" wrote:
> 

Report this thread to moderator Post Follow-up to this message
Old Post
Robert Kinesta
09-01-05 01:23 AM


Sponsored Links





Last Thread Next Thread
Post New Thread

MS SQL Server archive

Show a Printable Version Email This Page to Someone! Receive updates to this thread
Microsoft SQL Server
Access database support
PostgreSQL Replication
SQL Server ODBC
FoxPro Support
PostgreSQL pgAdmin
SQL Server Clustering
MySQL ODBC
Web Applications with dBASE
SQL Server CE
MySQL++
Sybase Database Support
MS SQL Full Text Search
PostgreSQL Administration
SQL Anywhere support
DB2 UDB Database
Paradox Database Support
Filemaker Database
Berkley DB
SQL 2000/2000i database
ASE Database
Forum Jump:
All times are GMT. The time now is 12:09 PM.

 
Mobile devices forum | Database support forum archive




Copyrights DropTable.com Database Support Forum 2004 - 2006