SQL Server Performance Forum – Threads Archive

Sql Server Compatibility Level

Hi i’am very new to DBA side , my question here is when i’am migrating from sql2000 database to sql2005 server do i need to change its compatibility level???
i already got some points on compatibility level 90 eg. *= or =* will not work….
if i put my database or sql2005 server’s compatibility level to 80 will there be any performance issue????will i get the benefit of migrating the application to sql2005???
can anyone clearly explain on this matter…………. Thanking in advance Mat

---

If you are migrating using UPGRADE then you need to worry about it.
I believe if you put the compatibility level to 80 the system may not be able to use few enhancement in 90 version in this case. http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx upgrade handbook Refer to the books online about Backward compatibility information. 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.

---

SQL Server 2005 Books Online
SQL Server 2005 Database Engine Backward Compatibility http://msdn2.microsoft.com/en-us/library/ms143532.aspx
Mohammed U.

---

Thanks guys for your replies and provided links but still i can’t figure out the exact performance problem if i set my server compatibility to level 80 on SQL2005. Mat

---

Why don’t you run a test case in thsi regard, I believe that way you can know what is happening on Application side. 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.

---

]]>