SQL Server Performance

Windows 2003 SP1 for SQL Server 2000

Discussion in 'General DBA Questions' started by knightprincesqlsp, Mar 24, 2006.

  1. knightprincesqlsp New Member

    How beneficial will it be for SQL Server 2000 to upgrade it's OS from Windows 2000 to Windows 2003 SP1?

    Any precaution when upgrading?
    knightprincesqlsp, Mar 24, 2006
    #2

  2. Argyle New Member

    Beneficial:
    Not much I think but it's usually best to keep both OS and SQL up to date on service packs.

    Precautions:
    If you use MSDTC there will be new security options after applying SP1 for Windows 2003. So verify functionality after upgrade.
    Argyle, Mar 27, 2006
    #2

  3. satya Moderator

    http://geekswithblogs.net/mrnat/archive/2005/04/13/33403.aspx about what Argyle was referencing on MSDTC.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Mar 27, 2006
    #2

Share This Page