1

We have a Sql Server 2005 DB. For whatever reason, the compatibility level (e.g. via sp_dbcmptlevel) is set to 80 (which is Sql Server 2000).

What are the consequences of that? Is there a performance penalty for my apps because of it?

AngryHacker
  • 59,598
  • 102
  • 325
  • 594

1 Answers1

2

See if this helps: Does running a SQL Server 2005 database in compatibility level 80 have a negative impact on performance?

Edit: Not mentioned in the other thread, I think this one is quite interesting as well: http://www.sqlmag.com/Article/ArticleID/49643/sql_server_49643.html

Community
  • 1
  • 1
Frank Kalis
  • 1,322
  • 9
  • 8