Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesAre 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.
Post Follow-up to this messageWe 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.
Post Follow-up to this messageAny 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: >
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread