탐색 건너뛰기

Mid-June 2016 brings compatibility level 130 for new Azure SQL databases

2016년 5월 10일 화요일

Azure SQL Database runs millions of databases under several different T-SQL versions, preserving backward compatibility for applications. SQL Database implements a versioning technique called "compatibility level." The compatibility levels are:

  • SQL Server 2008 and SQL Database v11: 100
  • SQL Server 2012: 110
  • SQL Server 2014 and SQL Database: 120
  • SQL Server 2016 and SQL Database v12: 130

Use of compatibility level 130 enables developers to benefit from SQL Server 2016 query processor enhancements. The enhancements can improve your query executions by leveraging new features such as parallel plan execution, serial batch mode execution, and new query plan estimates, to name a few.

Starting in mid-June 2016, the default Azure SQL Database compatibility level will change from 120 to 130 for newly created databases. Databases created before mid-June 2016 will not be affected and will maintain their current compatibility level (100, 110, or 120).

For pre-existing databases, we strongly encourage you to adopt this new compatibility level so you can benefit from the new query processor features and increase your application performance. You can change the compatibility level by running a simple T-SQL statement: “ALTER DATABASE <Your-Database-Name-Here> SET COMPATIBILITY_LEVEL = 130”.

Experience shows that most workloads run as-is under compatibility level 130. However, there are always some exceptions, and due diligence is important to determine how much you can benefit from the enhancements. If you want to dive deeper on this matter, you can review the documentation: Improved query performance with compatibility level 130 in Azure SQL Database.

체험 계정

Azure 크레딧 $200을 얻고 인기 서비스를 12개월 간 체험해 보세요.

시작

Visual Studio

구독자는 매년 최대 $1800 상당의 Azure 서비스를 이용할 수 있습니다.

지금 활성화

스타트업

Microsoft for Startups에 참가하고 Azure 서비스를 체험해 보세요.

자세한 정보