Expert SQL Server In-Memory OLTP

2. Auflage 2017
ISBN: 978-1-4842-2771-8
Verlag: Apress

Buch, Englisch, 304 Seiten, Format (B × H): 155 mm x 235 mm, Gewicht: 4978 g

The major recent feature in SQL Server is support for in-memory online transaction processing. It is one of the features Microsoft has been most vocal about. It includes support for tables that reside entirely in-memory instead of on-disk, enabling tremendous throughput and performance improvements. Also included in this feature set is support for natively-compiled stored procedures. These enable T-SQL to be compiled to machine code, again enabling tremendous performance improvements. All database professionals must learn and understand this feature set and how to use it, and Expert SQL Server In-Memory OLTP, 2nd Edition is the book that will meet this need in the marketplace for deep and accurate information on in-memory tables and natively-compiled stored procedures.

Zielgruppe

Popular/general

Autoren/Hrsg.

Korotkevitch, Dmitri

Fachgebiete

• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Datenbankprogrammierung SQL Server/MS SQL

Inhaltsverzeichnis

Introduction

1. Why In-Memory OLTP?

2. In-Memory OLTP Objects

3. Memory-Optimized Tables

4. Hash Indexes

5. Nonclustered Indexes

6. Memory Consumers and Off-Row Storage

7. Columnstore Indexes

8. Transaction Processing in In-Memory OLTP

9. In-Memory OLTP Programmability

10. Data Storage, Checkpoint, and Recovery

11. Garbage Collection

12. Deployment and Management

13. Utilizing In-Memory OLTP

14. Appendix A: Memory Pointer Management

15. Appendix B: Page Splitting and Page Merging in Nonclustered Indexes

16. Appendix C: Analyzing the States of Checkpoint Files

17. Appendix D: In-Memory OLTP Migration Tools

Über Autor(innen)

Dmitri Korotkevitch is a Microsoft Data Platform MVP and Microsoft Certified Master (SQL Server 2008) with more than 20 years of IT experience, including years of experience working with Microsoft SQL Server as an Application and Database Developer, Database Administrator, and Database Architect. He specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock. Dmitri regularly speaks at various Microsoft and SQL PASS events, and he provides SQL Server training to clients around the world.