SQL Server Performance

Pros/Cons of using Win 2003 over Win 2000 for SQL

Discussion in 'Performance Tuning for DBAs' started by stevekeily, Nov 19, 2003.

  1. stevekeily New Member

    We've recently got a new Server in.
    The server has 16Gb of RAM, 8 cpus etc
    We now have a choice of sticking with Windows 2000 Advanced Server or
    going with Windows 2003 Enterprise edition.

    Besides being able to use more RAM and having to use Service pack 3a
    in Win 2003

    Any pros/cons of both ?
    Any recommendations ?

    We use Full text, replication, analysis services etc
    What issues / Enhancements has MS introduced for sp3A ?
    I know that once Service pack 3A is installed all full text indexes
    are automatically rebuilt..

    Anything else to look out for ?



    stevekeily, Nov 19, 2003
    #2

  2. satya Moderator

    Read thru README.HTM for SP3A and other service packs to know in-depth of information.
    And the setup would be find with no issues if proper upgradation clicks without any errors.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
    satya, Nov 19, 2003
    #2

  3. bradmcgehee New Member

    The biggest advantage of using Widows 2003 over Windows 2000 is the automatic performance boost you get. While the exact amount of performance benefit will vary, your SQL Server may get a boost from 10-20%, just my migrating to Windows 2003. Most of this performance boost is due to the rewrite of Windows 2003's disk I/O subsystem.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
    bradmcgehee, Nov 20, 2003
    #2

Share This Page