Expert Performance Indexing in SQL Server 2019: Toward Faster Results and Lower Maintenance
暫譯: SQL Server 2019 專家效能指標：實現更快的結果與更低的維護成本

Strate, Jason

Expert Performance Indexing in SQL Server 2019: Toward Faster Results and Lower Maintenance

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

相關主題

商品描述

Take a deep dive into perhaps the single most important facet of good performance: indexes, and how to best use them. Recent updates to SQL Server have made it possible to create indexes in situations that in the past would have prevented their use.
Other improvements covered in this book include new dynamic management views, the ability to pause and resume index maintenance, and the ability to more easily recover from failures during index creation and maintenance operations. This new edition also brings new content around the indexing of columnstore and in-memory tables, showing how these new types of tables and the queries that execute against them can also benefit from good indexing practices. 
The book begins with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. You will better understand what indexes are doing in the database and what can be done to mitigate and improve their effect on performance. You will get a look at the Index Advisor now available in Azure SQL Database, and learn how to review and maintain the health of your indexes. The final chapters present a guided tour through a number of scenarios showing approaches you can take to investigate, mitigate, and improve the performance of your database.

What You Will Learn

  • Properly index row store, columnstore, and in-memory tables
  • Review statistics to understand indexing choices made by the optimizer
  • Apply indexing strategies such as covering indexes, included columns, and index intersections
  • Recognize and remove unnecessary indexes
  • Design effective indexes for full-text, spatial, and XML data types
  • Manage the big picture: Encompass all indexes in a database, and all database instances on a server



Who This Book Is For
Database administrators and developers who are ready to lift the performance of their database environment by thoughtfully building indexes to speed up queries that matter the most and make a difference to the business

商品描述(中文翻譯)

深入探討良好性能中或許是最重要的面向：索引，以及如何最佳化使用它們。最近對 SQL Server 的更新使得在過去會阻礙其使用的情況下也能創建索引。

本書涵蓋的其他改進包括新的動態管理視圖、暫停和恢復索引維護的能力，以及在索引創建和維護操作期間更容易從故障中恢復的能力。這一新版還帶來了有關列存儲（columnstore）和內存表（in-memory tables）索引的新內容，展示了這些新類型的表及其執行的查詢如何也能受益於良好的索引實踐。

本書首先解釋了索引的類型以及它們在數據庫中的存儲方式。深入探討主題後，您將查看由索引累積的統計數據以及針對索引的統計數據。您將更好地理解索引在數據庫中所做的工作，以及可以採取哪些措施來減輕和改善它們對性能的影響。您將了解現在在 Azure SQL Database 中可用的索引建議工具（Index Advisor），並學習如何檢查和維護索引的健康狀態。最後幾章將帶您參觀多個場景，展示您可以採取的調查、減輕和改善數據庫性能的方法。



您將學到什麼


  • 正確地為行存儲（row store）、列存儲（columnstore）和內存表（in-memory tables）建立索引

  • 檢查統計數據以了解優化器所做的索引選擇

  • 應用索引策略，如覆蓋索引（covering indexes）、包含列（included columns）和索引交集（index intersections）

  • 識別並移除不必要的索引

  • 為全文（full-text）、空間（spatial）和 XML 數據類型設計有效的索引

  • 管理全局視野：涵蓋數據庫中的所有索引，以及伺服器上的所有數據庫實例





本書適合誰閱讀

準備通過深思熟慮地建立索引來提升數據庫環境性能的數據庫管理員和開發人員，以加速最重要的查詢並對業務產生影響。

作者簡介

Jason Strate is a database architect and administrator with more than 15 years of experience. He has been a recipient of Microsoft's Most Valuable Professional designation for SQL Server since July 2009. His experience includes design and implementation of both OLTP and OLAP solutions, as well as assessment and implementation of SQL Server environments for best practices, performance, and high availability solutions. He is a SQL Server MCITP and participated in the development of Microsoft Certification exams for SQL Server 2008.
Jason is actively involved with his local PASS chapter (SQL Server User Group) and serves as its director of program development. He worked with the board to organize the PASSMN SQL Summit 2009 for the local community. He enjoys helping others in the SQL Server community and does this by presenting at technical conferences and user group meetings. Most recently, he has presented at the SSWUG Virtual Conferences, TechFuse, numerous SQL Saturdays, and at PASSMN user group meetings.
Jason is a contributing author for the Microsoft whitepaper on Empowering Enterprise Solutions with SQL Server 2008 Enterprise Edition. He is an active blogger with a focus on SQL Server and related technologies.

作者簡介(中文翻譯)

Jason Strate 是一位擁有超過 15 年經驗的資料庫架構師和管理員。他自 2009 年 7 月以來一直是 Microsoft SQL Server 的最有價值專業人士（Most Valuable Professional, MVP）。他的經驗包括 OLTP 和 OLAP 解決方案的設計與實施，以及對 SQL Server 環境的評估和實施，以確保最佳實踐、性能和高可用性解決方案。他是 SQL Server MCITP，並參與了 Microsoft SQL Server 2008 認證考試的開發。

Jason 積極參與當地的 PASS 分會（SQL Server 使用者小組），並擔任其計畫發展主任。他與董事會合作，為當地社區組織了 PASSMN SQL Summit 2009。他喜歡幫助 SQL Server 社區中的其他人，並通過在技術會議和使用者小組會議上演講來實現這一點。最近，他在 SSWUG 虛擬會議、TechFuse、眾多 SQL Saturdays 和 PASSMN 使用者小組會議上發表了演講。

Jason 是 Microsoft 白皮書《使用 SQL Server 2008 企業版賦能企業解決方案》的貢獻作者。他是一位活躍的部落客，專注於 SQL Server 及相關技術。

類似商品