Cargando…
Expert SQL server in-memory OLTP /
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...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
[New York, New York] :
Apress,
[2015]
|
| Colección: | Expert's voice in SQL server.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- 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; Control Flow; Query Surface Area; Operators; Build-In Functions; 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; PRECREATED CFP State; UNDER CONSTRUCTION CFP State and CHECKPOINT Process; ACTIVE CFP State; MERGE TARGET and MERGED SOURCE CFP States and Merge Process
- REQUIRED FOR BACKUP/HA, IN TRANSITION TO TOMBSTONE, and TOMBSTONE CFP 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; Estimating the Amount of Memory for In-Memory OLTP; Administration and Monitoring Tasks; Limiting the Amount of Memory Available to In-Memory OLTP; Monitoring Memory Usage for Memory-Optimized Tables