Home Page Icon
Home Page
Table of Contents for
Title
Close
Title
by Dmitri Korotkevitch
Expert SQL Server In-Memory OLTP
Cover
Title
Copyright
Dedication
Contents at a Glance
Contents
About the Author
About the Technical Reviewer
Acknowledgments
Introduction
Chapter 1 : Why In-Memory OLTP?
Background
In-Memory OLTP Engine Architecture
Summary
Chapter 2 : In-Memory OLTP Objects
Preparing a Database to Use In-Memory OLTP
Creating Memory-Optimized Tables
Working with Memory-Optimized Tables
In-Memory OLTP in Action: Resolving Latch Contention
Summary
Chapter 3 : Memory-Optimized Tables
On-Disk vs. Memory-Optimized Tables
Introduction to the Multiversion Concurrency Control
Data Row Format
Native Compilation of Memory-Optimized Tables
Memory-Optimized Tables: Surface Area and Limitations
Supported Data Types
Constraints and Table Features
Database-Level Limitations
High Availability Technologies Support
Summary
Chapter 4 : Hash Indexes
Hashing Overview
Much Ado About Bucket Count
Bucket Count and Performance
Choosing the Right Bucket Count
Changing the Bucket Count in the Index
Hash Indexes and SARGability
Statistics on Memory-Optimized Tables
Summary
Chapter 5 : Nonclustered Indexes
Working with Nonclustered Indexes
Creating Nonclustered Indexes
Using Nonclustered Indexes
Nonclustered Indexes Internals
Bw-Tree Overview
Index Pages and Delta Records
Obtaining Information About Nonclustered Indexes
Hash Indexes vs. Nonclustered Indexes
Summary
Chapter 6 : In-Memory OLTP Programmability
Native Compilation
Natively Compiled Stored Procedures
Creating Natively Compiled Stored Procedures
Supported T-SQL Features
Atomic Blocks
Optimization of Natively Compiled Stored Procedures
Interpreted T-SQL and Memory-Optimized Tables
Performance Comparison
Memory-Optimized Table Types and Variables
Summary
Chapter 7 : Transaction Processing in In-Memory OLTP
ACID, Transaction Isolation Levels, and Concurrency Phenomena Overview
Transaction Isolation Levels in In-Memory OLTP
Cross-Container Transactions
Transaction Lifetime
Summary
Chapter 8 : Data Storage, Logging, and Recovery
Data Storage
Checkpoint File Pairs States
Transaction Logging
Recovery
Summary
Chapter 9 : Garbage Collection
Garbage Collection Process Overview
Garbage Collection-Related Data Management Views
Exploring the Garbage Collection Process
Summary
Chapter 10 : Deployment and Management
Hardware Considerations
CPU
I/O Subsystem
Memory
Administration and Monitoring Tasks
Limiting the Amount of Memory Available to In-Memory OLTP
Monitoring Memory Usage for Memory-Optimized Tables
Monitoring In-Memory OLTP Transactions
Collecting Execution Statistics for Natively Compiled Stored Procedures
Metadata Changes and Enhancements
Catalog Views
Data Management Views
Extended Events and Performance Counters
Summary
Chapter 11 : Utilizing In-Memory OLTP
Design Considerations for the Systems Utilizing In-Memory OLTP
Addressing In-Memory OLTP Limitations
8,060-Byte Maximum Row Size Limit
Lack of Uniqueness and Foreign Key Constraints
Case-Sensitivity Binary Collation for Indexed Columns
Thinking Outside the In-Memory Box
Importing Batches of Rows from Client Applications
Using Memory-Optimized Objects as Replacements for Temporary and Staging Tables
Using In-Memory OLTP as Session - or Object State-Store
Using In-Memory OLTP in Systems with Mixed Workloads
Summary
Appendix A: Memory Pointers Management
Memory Pointers Management
Summary
Appendix B: Page Splitting and Page Merging in Nonclustered Indexes
Nonclustered Indexes Internal Maintenance
Page Splitting
Page Merging
Summary
Appendix C: Analyzing the States of Checkpoint File Pairs
Sys.db_dm_xtp_checkpoint_files View
The Lifetime of Checkpoint File Pairs
Summary
Appendix D: In-Memory OLTP Migration Tools
Management Data Warehouse Enhancements
Memory Optimization and Native Compilation Advisors
Summary
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Cover
Next
Next Chapter
Copyright
Expert SQL Server In-Memory OLTP
Dmitri Korotkevitch
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset