Post reply

OS Upgrade

  • December 17, 2003 at 4:09 am

    #161265

    OS Upgrade

    We are planning for an OS upgrade to Win 2000 ,How it will affect the performance of our SQL 2000 data base instance. Any Idea ?, Please post your experience and Comments

    regards

    John

  • December 17, 2003 at 8:34 am

    #486695

    It's been a long while, but I seem to remember performance decreasing when I upgraded from NT 4 to Windows 2000. Performance increased when I upgraded from Windows 2000 to Windows 2003.

    The databases I had at the time were fairly small (under 5 GB) and not very heavilly utlizied. Your experience may be different.

  • December 17, 2003 at 8:49 am

    #486703

    Steev Jones ? Any comments

    Thanks for Mr jxflagg

    regards

    john

  • December 18, 2003 at 5:47 am

    #486901

    The two times that we did that was an apple to apples comparision we saw a slight improvement. Although we did not do a NT to Win2k in place upgrade, we did a hardware switch. Same type hardware/specs just reinstalled SQL Server on new, renamed new to old name restored dbs. It was not significant and probably a less defragged hard drive probably helped also. I believe the edition of SQL Server also makes a difference. SQL Server 2000 takes advantage of Win2K whereas SQL Server 7 really does not. Our typical upgrade of operating system or SQL Server usually means a newer server that has more horsepower but in the above two cases it was one for one.

  • December 18, 2003 at 7:44 am

    #486943

    We generally saw improvements, not necessarily enough to write home about, but 5 to 10 %.

    So far Win2003 is proving to be a screamer. Testing is still early, and we have been working more on functional vs. performance testing.

    KlK, MCSE


    KlK

  • December 18, 2003 at 8:10 am

    #486952

    On Win2003 is your database(s) large with alot of transactions? In the presentation I saw about Win2003 and SQL Server the only benefit was for large databases with heavy transactions.

  • December 18, 2003 at 5:51 pm

    #487121

    On a related note but NOT really related to SQL, we found a lot more long term stability in the servers we did a wipe/reinstall than those we did an upgrade on.

    I can't say why, and I don't have any specific details, but in particular a couple of domain controllers that were upgraded we just had a lot of flakey problems until they got rebuilt.

  • December 19, 2003 at 1:47 am

    #487153

    if we are going for a fresh installation ,what will happen to our ,trusted SQL users ,

    I mean win NT integrated security schem will create problem ?

  • December 22, 2003 at 9:54 pm

    #487541

    I saw some inprovements moving from NT4 to W2K with SQL 2000, can't remember the details though. We have a lot of large DB's here and have been testing Win 2003 with SQL 2000 and have seen major problems and probably won't be upgrading any time soon.

    Cheers,

    Angela

  • December 23, 2003 at 5:42 am

    #487572

    Re johncyriac and trusted users -- is this on a domain or a workgroup? If your trusted users are domain users AND this isn't the only domain controller, this should not be a big deal. You should consider backing up and restoring SQL's databases so you get the same structure and jobs, how thoroughly you do that (e.g. master, msdb, etc.) vs. scripting and reinstalling (e.g. jobs) is a more complicated question.

    Note that the thought to reinstall vs. upgrade is really an OS issue. Clearly it's more disruptive to SQL to start fresh on a new platform. Just our experience has been it is a more stable W2K platform.

    Re:

    quote:

    We have a lot of large DB's here and have been testing Win 2003 with SQL 2000 and have seen major problems

    Perhaps a question for another thread, but would you care to share? We are planning a W2003 upgrade on our DW servers next month. INitial testing has been OK, but also incomplete because I don't have a test server big enough to load the big databases.

  • December 23, 2003 at 4:19 pm

    #487691

    Started a new thread on Windows 2003 performance.

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply