Book description
Expert SQL Server In-Memory OLTP is a deep dive into one of the most significant features of SQL Server 2014 – support for In-Memory Online Transaction Processing. The 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 transactional throughput to handle thousands of transactions per second supporting millions of customers.
Dmitri Korotkevitch is the five-star author of Pro SQL Server Internals, and now brings his same combination of clear thinking and deep expertise to the question of how to recognize the opportunities and benefit from Microsoft’s In-Memory OLTP feature set in SQL Server 2014.
Learn the architecture and the internals in order to recognize when in-memory OLTP can make a difference. Learn useful scenarios for thoughtfully incorporating In-Memory support into existing applications. Recognize opportunities for In-Memory OLTP in new development. Don’t be without Dmitri Korotkevitch and the deep expertise he imparts in Expert SQL Server In-Memory OLTP as you move forward in using SQL Server’s new and important In-Memory OLTP feature set.
Table of contents
- Cover
- Title
- Copyright
- Dedication
- Contents at a Glance
- Contents
- About the Author
- About the Technical Reviewer
- Acknowledgments
- Introduction
- Chapter 1 : Why In-Memory OLTP?
- Chapter 2 : In-Memory OLTP Objects
- Chapter 3 : Memory-Optimized Tables
- Chapter 4 : Hash Indexes
- Chapter 5 : Nonclustered Indexes
- Chapter 6 : In-Memory OLTP Programmability
- Chapter 7 : Transaction Processing in In-Memory OLTP
- Chapter 8 : Data Storage, Logging, and Recovery
- Chapter 9 : Garbage Collection
- Chapter 10 : Deployment and Management
- Chapter 11 : Utilizing In-Memory OLTP
- Appendix A: Memory Pointers Management
- Appendix B: Page Splitting and Page Merging in Nonclustered Indexes
- Appendix C: Analyzing the States of Checkpoint File Pairs
- Appendix D: In-Memory OLTP Migration Tools
- Index
Product information
- Title: Expert SQL Server In-Memory OLTP
- Author(s):
- Release date: September 2015
- Publisher(s): Apress
- ISBN: 9781484211366
You might also like
book
SQL Server DMVs in Action
SQL Server DMVs in Action is a practical guide that shows you how to obtain, interpret, …
book
Pro SQL Server Wait Statistics
Pro SQL Server Wait Statistics is a practical guide for analyzing and troubleshooting SQL Server performance …
book
Inside Microsoft® SQL Server® 2008: T-SQL Querying
Tackle the toughest set-based querying and query tuning problems—guided by an author team with in-depth, inside …
book
Microsoft® SQL Server 2012 Unleashed
Buy the print version of¿ and get the eBook version for free! eBook version includes chapters …