SQL Server 2017 Query Performance Tuning: Troubleshoot and Optimize Query Performance

© Grant Fritchey 2018

Grant FritcheySQL Server 2017 Query Performance Tuninghttps://doi.org/10.1007/978-1-4842-3888-2_25

25. Automated Tuning in Azure SQL Database and SQL Server

Grant Fritchey¹ 

(1)

Grafton, Massachusetts, USA

 

While a lot of query performance tuning involves detailed knowledge of the systems, queries, statistics, indexes, and all the rest of the information put forward in this book, certain aspects of query tuning are fairly mechanical in nature. The process of noticing a missing index suggestion and then testing whether that index helps or hurts a query and whether it hurts other queries could be automated. The same thing goes for certain kinds of bad parameter sniffing where it’s clear that one plan is superior to another. Microsoft ...