Expert SQL Server In-Memory OLTP
暫譯: 專家級 SQL Server 內存 OLTP

Dmitri Korotkevitch

Expert SQL Server In-Memory OLTP
  • 出版商: Apress
  • 出版日期: 2017-09-04
  • 售價: $2,040
  • 貴賓價: 9.5 折 $1,938
  • 語言: 英文
  • 頁數: 304
  • 裝訂: Paperback
  • ISBN: 1484227719
  • ISBN-13: 9781484227718
  • 相關分類: MSSQL、SQL

    • 海外代購書籍(需單獨結帳)

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

相關主題

商品描述

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）。本書涵蓋最新的發展，包括對於離行儲存（off-row storage）、列儲索引（columnstore indexes）和操作分析（operational analytics）的支援、可程式設計性和原生編譯（native compilation）的變更等。這本書描述了記憶體內 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

**您將學到的內容**

- 理解 SQL Server 如何在記憶體優化的表中儲存和處理數據
- 正確設計和索引記憶體優化的表
- 計劃成功的部署，包括所需的記憶體大小和 I/O 配置
- 通過創建原生編譯模組來加速 T-SQL 處理
- 監控和報告您的記憶體內 OLTP 解決方案的效益和性能
- 在現有系統和混合工作負載的系統中受益於該技術

**本書適合誰閱讀**

應用程式開發人員和資料庫管理員，他們創建和管理線上交易處理（OLTP）系統；特別是那些希望利用 SQL Server 新推出的記憶體內 OLTP 來顯著改善其系統性能和吞吐量的人士。

類似商品