Intelligent Query Processing
Intelligent Query Processing (IQP) is a family of features that were introduced in Microsoft SQL Server 2017 as adaptive query processing and has been expanded with new features in Microsoft SQL Server 2019. By upgrading to SQL Server 2019 and with compatibility level 150, most workloads will see performance improvements due to added intelligence in the query optimizer.
Intelligent Query Processing features are automatically enabled based on the "COMPATIBLITY_LEVEL" of the database. To take advantage of the latest IQP features, set the database compatibility to 150.
Most of these are also available in Azure SQL, but it is best to check current documentation on exactly what is available there as this changes.
The following table summarizes some of the IQP features.
Table 1.14: Table summarizing IQP features
- These features can be disabled and monitored.
- For more information, refer to https://docs.microsoft.com/en-us/sql/relational-databases/performance/intelligent-query-processing?view=sql-server-2017.