Expert SQL Server In-Memory OLTP

Dmitri Korotkevitch

  • 出版商: Apress
  • 出版日期: 2017-09-04
  • 售價: $1,680
  • 貴賓價: 9.5$1,596
  • 語言: 英文
  • 頁數: 304
  • 裝訂: Paperback
  • ISBN: 1484227719
  • ISBN-13: 9781484227718
  • 相關分類: MSSQLSQL
  • 海外代購書籍(需單獨結帳)

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

商品描述

Take a deep dive into one of the most significant SQL Server features–support for In-Memory Online Transaction Processing. The latest developments are covered, including support of off-row storage, columnstore indexes and operational analytics, changes in programmability and native compilation, and more. This book describes the architecture and internals of the In-Memory OLTP Engine and explains how to develop, deploy, and maintain systems using it. With it you can dramatically increase transaction throughput to handle thousands of transactions per second supporting millions of customers.
 
Learn the architecture and the internals of In-Memory OLTP in order to recognize when technology can make a difference. Recognize opportunities for In-Memory OLTP in new development and understand how to benefit from it in existing systems. Don’t be without Dmitri Korotkevitch and the deep expertise he imparts in Expert SQL Server In-Memory OLTP, 2nd Edition as you move forward in using SQL Server’s In-Memory OLTP technology. 
 
Dmitri Korotkevitch is the five-star author of Pro SQL Server Internals, and brings the same combination of clear thinking and deep expertise to help you in this second edition. The book:
  • Explains In-Memory OLTP internals, architecture and programmability, including data storage, indexing, multi-version concurrency control, transaction logging and recovery, and native compilation
  • Covers SQL Server 2016 technology enhancements, including columnstore indexes and off-row storage
  • Guides in using In-Memory OLTP in new development and existing systems


  •  
What You’ll Learn
  • Grasp how SQL Server stores and works with data in memory-optimized tables
  • Properly design and index memory-optimized tables
  • Plan successful deployments, including the required memory size and I/O configuration
  • Accelerate T-SQL processing through the creation of natively compiled modules
  • Monitor and report on the benefits and performance of your In-Memory OLTP solutions
  • Benefit from the technology in existing systems and in the systems with the mixed workload
Who This Book Is For
 

Application developers and database administrators who create and manage online transaction processing (OLTP) systems; in particular, those wanting to take advantage of SQL Server’s new offering of in-memory OLTP to dramatically improve performance and throughput of their systems

 
 

商品描述(中文翻譯)

深入研究SQL Server最重要的功能之一——支援內存線上交易處理(In-Memory Online Transaction Processing)。本書涵蓋了最新的發展,包括對離散存儲、列存索引和操作分析的支援,以及可編程性和本地編譯的變化等。本書描述了內存OLTP引擎的架構和內部結構,並解釋了如何開發、部署和維護使用它的系統。使用內存OLTP技術,您可以大幅提高交易吞吐量,處理每秒數千筆交易,支援數百萬個客戶。

深入了解內存OLTP的架構和內部結構,以便在適當的時候選擇使用這項技術。了解在新開發中使用內存OLTP的機會,並了解如何在現有系統中受益於它。在使用SQL Server的內存OLTP技術時,不要錯過Dmitri Korotkevitch在《Expert SQL Server In-Memory OLTP, 2nd Edition》中所傳授的深入專業知識。

Dmitri Korotkevitch是《Pro SQL Server Internals》的五星級作者,他在第二版中結合了清晰的思維和深入的專業知識,幫助您更好地使用這項技術。本書包括以下內容:

- 解釋內存OLTP的內部結構、架構和可編程性,包括數據存儲、索引、多版本並發控制、事務日誌和恢復,以及本地編譯。
- 詳細介紹SQL Server 2016的技術增強功能,包括列存索引和離散存儲。
- 指導如何在新開發和現有系統中使用內存OLTP。
- 學習如何在內存優化表中存儲和處理數據。
- 正確設計和索引內存優化表。
- 計劃成功的部署,包括所需的內存大小和I/O配置。
- 通過創建本地編譯模塊加速T-SQL處理。
- 監控和報告您的內存OLTP解決方案的效益和性能。
- 在現有系統和混合工作負載系統中受益於這項技術。

本書適合以下讀者:

- 應用程序開發人員和數據庫管理員,他們創建和管理在線事務處理(OLTP)系統,特別是那些希望利用SQL Server的內存OLTP新功能,大幅提高系統性能和吞吐量的讀者。