SQL Server Performance

SQL 2000 Database restore to Sql 2005

Discussion in 'SQL Server 2005 General DBA Questions' started by Akthar, Sep 3, 2006.

  1. Akthar New Member

    Hi all,

    When restoring an SQL 2000 Database to SQL 2005, The compatibility level is set to sql 2000. Does this option has any implication on the performance of the server. Given that SQL 2005 is supposed to have better performance?

    Thanks



    AKTHAR
    Akthar, Sep 3, 2006
    #2

  2. satya Moderator

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=673499&SiteID=1 neares information fyi.
    As of the performance i don't think this will be affected, but make sure the clients are not having such degrade of performance when connected using necessary protocols to SQL.

    Satya SKJ
    Microsoft SQL Server MVP
    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, Sep 4, 2006
    #2

  3. Akthar New Member

    Thanks for the link

    AKTHAR
    Akthar, Sep 4, 2006
    #2

Share This Page