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

Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and automated tuning on the Microsoft SQL Azure Database platform. Anyone responsible for writing or creating T-SQL запити will find valuable the insight into bottlenecks, including how to recognize them and eliminate them.

This book covers the latest in performance optimization features and techniques and current is with SQL Server 2017. If your queries are not running fast enough and you're tired of phone calls from frustrated users, then this book is the answer to your performance problems. 

SQL Server 2017 Query Performance Tuning is about more than quick tips and fixes. You'll learn to be proactive in establishing performance baselines using tools such as Performance Monitor and Extended Events. You'll recognize bottlenecks and defuse them before the phone rings.