Expert SQL Server Transactions and Locking: Concurrency Internals for SQL Server Practitioners
暫譯: 專家級 SQL Server 交易與鎖定：SQL Server 實務者的併發內部原理

Dmitri Korotkevitch

Expert SQL Server Transactions and Locking: Concurrency Internals for SQL Server Practitioners
  • 出版商: Apress
  • 出版日期: 2018-10-09
  • 售價: $2,350
  • 貴賓價: 9.5 折 $2,233
  • 語言: 英文
  • 頁數: 340
  • 裝訂: Paperback
  • ISBN: 1484239563
  • ISBN-13: 9781484239568
  • 相關分類: MSSQL、SQL

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

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

相關主題

商品描述

Master SQL Server’s Concurrency Model so you can implement high-throughput systems that deliver transactional consistency to your application customers. This book explains how to troubleshoot and address blocking problems and deadlocks, and write code and design database schemas to minimize concurrency issues in the systems you develop.
 
SQL Server’s Concurrency Model is one of the least understood parts of the SQL Server Database Engine. Almost every SQL Server system experiences hard-to-explain concurrency and blocking issues, and it can be extremely confusing to solve those issues without a base of knowledge in the internals of the Engine. While confusing from the outside, the SQL Server Concurrency Model is based on several well-defined principles that are covered in this book.
 
Understanding the internals surrounding SQL Server’s Concurrency Model helps you build high-throughput systems in multi-user environments. This book guides you through the Concurrency Model and elaborates how SQL Server supports transactional consistency in the databases. The book covers all versions of SQL Server, including Microsoft Azure SQL Database, and it includes coverage of new technologies such as In-Memory OLTP and Columnstore Indexes.
 
 
What You'll Learn
  • Know how transaction isolation levels affect locking behavior and concurrency
  • Troubleshoot and address blocking issues and deadlocks
  • Provide required data consistency while minimizing concurrency issues
  • Design efficient transaction strategies that lead to scalable code
  • Reduce concurrency problems through good schema design
  • Understand concurrency models for In-Memory OLTP and Columnstore Indexes
  • Reduce blocking during index maintenance, batch data load, and similar tasks
 
Who This Book Is For
 
SQL Server developers, database administrators, and application architects who are developing highly-concurrent applications. The book is for anyone interested in the technical aspects of creating and troubleshooting high-throughput systems that respond swiftly to user requests.

 

商品描述(中文翻譯)

掌握 SQL Server 的併發模型，以便實現高吞吐量系統，為您的應用程式客戶提供事務一致性。本書解釋了如何排除和解決阻塞問題和死鎖，並編寫代碼和設計數據庫架構，以最小化您開發的系統中的併發問題。

SQL Server 的併發模型是 SQL Server 數據庫引擎中最不被理解的部分之一。幾乎每個 SQL Server 系統都會遇到難以解釋的併發和阻塞問題，而在沒有引擎內部知識的基礎上解決這些問題可能會非常困惑。儘管從外部看起來令人困惑，但 SQL Server 併發模型是基於幾個明確定義的原則，本書將涵蓋這些原則。

理解 SQL Server 併發模型周圍的內部運作有助於您在多用戶環境中構建高吞吐量系統。本書將引導您了解併發模型，並詳細說明 SQL Server 如何在數據庫中支持事務一致性。本書涵蓋所有版本的 SQL Server，包括 Microsoft Azure SQL Database，並包括對新技術的介紹，如內存中 OLTP 和列存索引。

您將學到的內容：
- 知道事務隔離級別如何影響鎖定行為和併發性
- 排除和解決阻塞問題和死鎖
- 在最小化併發問題的同時提供所需的數據一致性
- 設計有效的事務策略，以實現可擴展的代碼
- 通過良好的架構設計減少併發問題
- 理解內存中 OLTP 和列存索引的併發模型
- 在索引維護、批量數據加載和類似任務中減少阻塞

本書適合對象：
SQL Server 開發人員、數據庫管理員和應用程式架構師，特別是那些正在開發高併發應用程式的人。本書適合任何對創建和排除高吞吐量系統的技術方面感興趣的人，這些系統能夠迅速響應用戶請求。

類似商品