Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dewacorp.alliances
452 Posts |
 Posted - 2006-09-30 : 18:21:10
|
| Hi thereAll servers that we have are using SP3a which at this stage have no issue so far. Due to Service Pack Support Retired for SP3a is coming soon which is 10-Jul-2007 .. few months from now, does anyone have an issue on SP4 (we have a clustering enviornments, active/pasive server environments)? In term of upgrade, is there anything that I should to look at / considered?Or does anyone still use the SP3a? Are you willing to upgrade this (I guess we have to due the support - just in case)? Any comments?Thanks |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-01 : 02:04:13
|
| "Or does anyone still use the SP3a?"Yes"Are you willing to upgrade"No!"In term of upgrade, is there anything that I should to look at / considered?"There are reported performance issues when mixing data types in WHERE clause / JOINs. I'm not aware of any means of reporting on these, so you are left with a full set of performance tests of your code to find them.We have a fully automated suite of testing for regression tests of application behaviour, but it really isn't sufficient for good regression testing of performance, and that would be a huge cost for us, so we haven't done it yet ...... the likelihood is that we will just move straight to SQL2005 instead, but we have no plans for that either just yet.Kristen |
 |
|
|
dewacorp.alliances
452 Posts |
Posted - 2006-10-01 : 17:29:33
|
| Thanks Kristen. I do like SP3a cause I think it's a stable environment for us.I guess you are right .. the option of moving from SQL Server 2000 SP3a to SQLServer 2005 ... it's better way to go. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-02 : 07:54:08
|
| You should, of course, check whether any of the fixes in SP4 are critical / beneficial for your environment ...Kristen |
|
|
|
dewacorp.alliances
452 Posts |
Posted - 2006-10-03 : 04:26:34
|
| Hi KristenIt's not so much that fixes in SP4 are critical / beneficial for our environment or not. What I am concerning is actually the SP3a will be retired from the support line. Or is it? Does this mean that I can't have a support unless I am upgrading to SP4 ... correct?Thanks |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-03 : 04:57:01
|
| Am, I'm with you now. Don't know the answer though, but presumably if push came to shove you could copy the DB to another server, upgrade it to SP4, check that you can reproduce the problem, then ask for support.A nuisance, for sure, but I personally I consider that I am very unlikely to need support on our SP3a serversKristen |
|
|
|
|
|
|
|
|
Service Pack Support Retired for SP3a