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

Grant Fritchey

  • 出版商: Apress
  • 出版日期: 2018-09-04
  • 定價: $2,625
  • 售價: 9.0$2,363
  • 語言: 英文
  • 頁數: 932
  • 裝訂: Paperback
  • ISBN: 1484238877
  • ISBN-13: 9781484238875
  • 相關分類: MSSQLSQL
  • 立即出貨(限量) (庫存=2)

買這商品的人也買了...

商品描述

Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and automated tuning on the Microsoft Azure SQL Database platform. Anyone responsible for writing or creating T-SQL queries 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 is current 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. You’ll learn some quick solutions too, but emphasis is on designing for performance and getting it right. The goal is to head off trouble before it occurs.

 

What You'll Learn

 

  • Use Query Store to understand and easily change query performance
  • Recognize and eliminate bottlenecks leading to slow performance
  • Deploy quick fixes when needed, following up with long-term solutions
  • Implement best practices in T-SQL to minimize performance risk
  • Design in the performance that you need through careful query and index design
  • Utilize the latest performance optimization features in SQL Server 2017
  • Protect query performance during upgrades to the newer versions of SQL Server

 

 

 
Who This Book Is For

Developers and database administrators with responsibility for application performance in SQL Server environments. Anyone responsible for writing or creating T-SQL queries will find valuable the insight into bottlenecks, including how to recognize them and eliminate them.

 

商品描述(中文翻譯)

識別並解決性能不佳的原因。您將學習在Microsoft Azure SQL Database平台上使用Query Store、自適應執行計劃和自動調整來優化性能。任何負責撰寫或創建T-SQL查詢的人都會發現有關瓶頸的洞察力非常有價值,包括如何識別並消除它們。

本書涵蓋了最新的性能優化功能和技術,並與SQL Server 2017保持同步。如果您的查詢運行速度不夠快,並且厭倦了來自沮喪的用戶的電話,那麼本書將是解決您性能問題的答案。

《SQL Server 2017查詢性能調整》不僅僅是提供快速提示和修復方法。您將學習如何主動建立性能基準,使用Performance Monitor和Extended Events等工具。您將識別並消除瓶頸,以免電話響起。您也將學習一些快速解決方案,但重點是設計性能並做到正確。目標是在問題發生之前解決麻煩。

您將學到什麼:

- 使用Query Store了解並輕鬆更改查詢性能
- 識別並消除導致性能下降的瓶頸
- 在需要時部署快速解決方案,並跟進長期解決方案
- 在T-SQL中實施最佳實踐,以減少性能風險
- 通過仔細的查詢和索引設計實現所需的性能
- 利用SQL Server 2017中的最新性能優化功能
- 在升級到較新版本的SQL Server時保護查詢性能

本書適合對SQL Server環境中應用程序性能負責的開發人員和數據庫管理員。任何負責撰寫或創建T-SQL查詢的人都會發現有關瓶頸的洞察力非常有價值,包括如何識別並消除它們。