image: ontrack

Automatic Query Performance Tuning in SQL Server Database

Microsoft has introduced many new features to improve query performance in SQL Server. For example, SQL Server 2017 and Azure SQL Database have Query Store, Adapting Query Processing, Automatic Tuning of SQL Query, etc. to improve the query performance.

In previous articles, we’ve learned how Query Store and Adapting Query Processing help SQL Server users to improve query execution performance.

In this article we’ll discuss Automatic Tuning, a new database feature that helps improve SQL Server query performance automatically.

Read More on Database Journal