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

Strate, Jason

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

商品描述

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 的最新更新使得在過去無法使用索引的情況下,現在可以創建索引。

本書還介紹了其他改進,包括新的動態管理視圖、暫停和恢復索引維護的能力,以及在索引創建和維護操作期間更容易從故障中恢復的能力。這個新版本還提供了關於列存儲和內存表索引的新內容,展示了這些新類型的表和執行對它們的查詢也可以從良好的索引實踐中受益。

本書首先解釋了索引的類型以及它們在數據庫中的存儲方式。更深入地研究這個主題,並進一步深入書中,您將研究索引和在索引上累積的統計信息。您將更好地了解索引在數據庫中的作用以及可以採取哪些措施來減輕和改善它們對性能的影響。您將瞭解 Azure SQL Database 中現有的索引建議器,並學習如何審查和維護索引的健康狀況。最後幾章將通過一些場景的引導,展示您可以採取的方法來調查、減輕和改善數據庫的性能。



您將學到什麼


  • 正確地為行存儲、列存儲和內存表建立索引

  • 審查統計信息以了解優化器所做的索引選擇

  • 應用索引策略,如覆蓋索引、包含列和索引交集

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

  • 為全文、空間和 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月以來,他一直是微軟SQL Server最有價值專家(Most Valuable Professional)的獲獎者。他的經驗包括設計和實施OLTP和OLAP解決方案,以及評估和實施SQL Server環境的最佳實踐、性能和高可用性解決方案。他是一位SQL Server MCITP,並參與了Microsoft Certification exams for SQL Server 2008的開發。

Jason積極參與當地的PASS章節(SQL Server User Group)並擔任其節目開發總監。他與該組織合作組織了當地社區的PASSMN SQL Summit 2009。他喜歡幫助SQL Server社區的其他人,通過在技術會議和用戶組會議上發表演講來實現這一目標。最近,他在SSWUG虛擬會議、TechFuse、許多SQL Saturdays和PASSMN用戶組會議上發表演講。

Jason是Microsoft白皮書《使用SQL Server 2008企業版增強企業解決方案》的共同作者。他是一位活躍的博客作者,專注於SQL Server和相關技術。