O'Reilly logo

SQL Server 2017 Query Performance Tuning: Troubleshoot and Optimize Query Performance by Grant Fritchey

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© 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 Fritchey1 
(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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required