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_1

1. SQL Query Performance Tuning

Grant Fritchey¹ 

(1)

Grafton, Massachusetts, USA

 

Query performance tuning continues to be a fundamental aspect of modern database maintenance and development. Yes, hardware performance is constantly improving. Upgrades to SQL Server—especially to the optimizer, which helps determine how a query is executed, and the query engine, which executes the query—lead to better performance all on their own. Further, automation within SQL Server will do some aspects of query tuning for you. At the same time, SQL Server instances are being put on virtual machines, either locally or in hosted environments, where ...