SQL Server Performance Forum – Threads Archive

Upgrade Win2000 to Win2003

What are the impacts if I upgrade my SQL2000 box from Win2000 to Win2003? CanadaDBA

From the SQL point of view, more performance.
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

OK! After 4 days I had only one respond to my question. Does it mean that there is no rsik at all?
I believe I get more performance but I am worry about any risk. Is there anybody who has done it before? Would you share your experience? CanadaDBA

If it was me, I’d back everything up, format the disks, and install Windows 2003 fresh, but I am a bit of a fusspot. Tom Pullen
DBA, Oxfam GB

Hi Farhad I have migrated a few servers to Windows 2003, but as per Tom’s response have always started from a clean install rather than upgrade in place. An upgraded w2k3 server is not the same as a newly installed w2k3 server. The latter is more secure and more performant (mainly due to unecessary services being switched off by default) So building a new server, installing sql2k then restoring database backups is the safest method, since it allows you to test the new server before commissioning it live (although it does require one new server to cycle into the existing set of servers. A small price to pay for risk mitigation I’d say <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ /> Cheers Twan

> OK! After 4 days I had only one respond to my question. Does it mean that there is no rsik at all? Id say upgrading an operating system on a production server is very risky!
Roll it out onto a dev server. You need a full schedule of testing, remember it is 4 years since Windows 2000, huge chunks of core code have changed even though the operating system may appear similar. I had some very odd problems with Windows 2003 server after upgrading… All resolved and rolled out to live now, but my tests on the dev server were not initially smooth, so be warned

Its better to perform a fresh installation in parallel to the current production system and upgrade the SQL server side and conduct the assessment about the performance. I completely agree with peers to upgrade on sQL level and do afresh installation on OS side. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thank you all for sharing your experience and ideas. I am agree with installing fresh Win2k3 and not upgrading the Win2k. My manager asked me to research on the Internet and ask those DBAs who have upgraded their Win2k to Win2k3 and see what problems they have encountered. If you have upgraded your Win2000 to Win2003 please share your experience. Also, if you have installed a fresh Win2003, share your experience. We have SQL2000 on Win2000. Before to Production, we have "test" and "dev" servers and we will upgrade/install on them first.
CanadaDBA

In any case if the upgrade part is deployed on OS part then I suggest and followed with a fresh install rather than upgrading from previous versions. All the installation in test & model office were completed using fresh installation.
If you wish to upgrade then refer to thishttp://www.microsoft.com/windowsserver2003/evaluation/whyupgrade/win2k/w2ktows03-2.mspx evaluation document for further information.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>