|
| Der Artikel wird am Ende des Bestellprozesses zum Download zur Verfügung gestellt. |
Expert SQL Server In-Memory OLTP
ISBN-13:
9781484227725
Veröffentl:
2017
Seiten:
304
Autor:
Dmitri Korotkevitch
eBook Typ:
PDF
eBook Format:
EPUB
Kopierschutz:
1 - PDF Watermark
Sprache:
Englisch
Beschreibung:
Take a deep dive into one of the most significant SQL Server features-support for In-Memory Online Transaction Processing. The latest developments are covered, including support of off-row storage, columnstore indexes and operational analytics, changes in programmability and native compilation, and more. This 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 transaction throughput to handle thousands of transactions per second supporting millions of customers.
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.
Kunden Rezensionen
Mehr zum Thema
Folgen Sie uns auf:
