SQL Server Performance

SQL Server 7.0 vs SQL 2000 Performance

Discussion in 'Performance Tuning for DBAs' started by likka, Oct 28, 2004.

  1. likka New Member

    Hi,

    Are there any performance benefits to upgrading to SQL Server 2000 from SQL Server 7.0. We don't use analysis services or any of the other add-on services, it is used in an OLTP system. The site struggles under duress so we are in the process of evaluating upgrade all alternatives, hardware and software.

    Given this context I was wondering if there was any performance gain to be had in upgrading to SQL 2000. Any thoughts or opinions would be appreciated.

    Many Thanks,

    Glenn.
  2. satya Moderator

    There are many advantages in upgrading SQL server from version 7 to 2000.

    The easy way is to perform UPGRADE using COPY DATABASE WIZARD or RESTORE complete ver.7 backup to 2K instance. No issues in upgrading the SQL and also, be sure that you know exactly how all of your apps connect to the database. Try to put together a document that lists all the config files/DSNs etc that need to be changed in order to get client apps talking to the new servers.

    Few articles for your reference on the point:
    http://www.sqlteam.com/item.asp?ItemID=9066
    http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx

    HTH

    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.

Share This Page