SQL Server Performance

Comparison: SQL 2000 vs. SQL 2005

Discussion in 'SQL Server 2005 General DBA Questions' started by raj17, Dec 20, 2005.

  1. raj17 New Member

    Hi,
    my company currently running SQL server 2000 and we wanted to upgrade to SQL Serevr 2005
    but my manager asked me to get report what are the difference. is there any web site where I can get SQL server 2000 V/S SQL Server 2005 comparison list..

    thanks
    raj
  2. Luis Martin Moderator

    Yes, go to Microsoft Web and you will find all comparision.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



  3. dineshasanka Moderator

  4. satya Moderator

    It will be also a good chance for you to download and install SQL 2005 evaluation edition from MS site and test with some resource intensive database on your test platform, that can give you more indepth information about what your manager is wanted.

    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.
  5. deepakontheweb New Member

    Hi:
    I am sure the comparision list between MS SQL Server 2000 and 2005 is quite long because of new features added into latest version..

    Check below link for New feature intrduced in SQL 2005
    -------------------------------------------------
    http://msdn2.microsoft.com/en-us/library/ms170363.aspx

    For SQL 2000
    -------------------------------------------------
    http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part1/c0261.mspx


    Ok.. once you are familiar with new changes..its time to find which changes can affect your databases if moving on sql2005..

    Microsoft SQL Server 2005 Upgrade Advisor
    -------------------------------------------------
    --It is a tool you can use to prepare for upgrades to SQL Server 2005. Upgrade Advisor analyzes installed SQL Server 2000 or SQL Server 7.0 components, and then generates a report that identifies issues that you must or should address to before or after upgrading to SQL Server 2005.
    http://msdn2.microsoft.com/en-us/library/ms144256.aspx


    Upgrading to SQL Server 2005
    -------------------------------------------------
    http://msdn2.microsoft.com/en-us/library/ms144245.aspx


    Article on "Upgrading to SQL Server 2005"
    -------------------------------------------------
    http://www.informit.com/articles/article.asp?p=421049&seqNum=4




    Deepak Kumar

    --This posting is provided “AS IS” with NO rights for the sake of knowledge sharing.
  6. joechang New Member

    my suggestion is get SQL2005 eval on a reasonable machine (data on multiple disks), best if you can have SQL 2000 on a second machine of approximately the same characteristic,
    then run you big reporting queries, and use that as a comparison

    instead of trying duplicate your full workload

Share This Page