SQL Server Performance Forum – Threads Archive
performance with compatibility level 80 in 2005
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, VinYou 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
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
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
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.
]]>