SQL Server Performance

performance with compatibility level 80 in 2005

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by vinman, Feb 8, 2007.

  1. vinman New Member

    The database in the sql 2005 test environment is running quicker than in the prod of sql server 2000 (same server setups) with compatibility level 90 but due to some programming bugs we will need to go back to level 80.





    Is there a performance hit if I run with a db on compatibility level 80 in sql server 2005?





    Thanks,

    Vin
  2. MohammedU New Member

  3. vinman New Member

    Very interesting article. Thanks for the info.



    quote:Originally posted by MohammedU

    You may see some difference depends on the usage...
    When you change cmpt to 8.0, sql engine has to be changed...new sql engine features will not work..

    http://msdn2.microsoft.com/en-us/library/ms143359.aspx


    MohammedU.
    Moderator
    SQL-Server-Performance.com
  4. satya Moderator

    It is a documented topic in the SQL Server books online, so you have to drill-through other links in this case to be assured.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page