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) |
MARC
| LEADER | 00000cam a2200000Ii 4500 | ||
|---|---|---|---|
| 001 | OR_ocn927112972 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 151028s2015 nyua o 001 0 eng d | ||
| 040 | |a UMI |b eng |e rda |e pn |c UMI |d OCLCF |d CEF |d OCLCQ |d OCLCO |d AZK |d COO |d UAB |d VLY |d OCLCO |d OCLCQ | ||
| 019 | |a 961621363 | ||
| 020 | |z 9781484211373 | ||
| 029 | 1 | |a AU@ |b 000061143589 | |
| 029 | 1 | |a GBVCP |b 897165659 | |
| 035 | |a (OCoLC)927112972 |z (OCoLC)961621363 | ||
| 037 | |a CL0500000665 |b Safari Books Online | ||
| 050 | 4 | |a QA76.9.C55 | |
| 082 | 0 | 4 | |a 004 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Korotkevitch, Dmitri, |e author. | |
| 245 | 1 | 0 | |a Expert SQL server in-memory OLTP / |c Dmitri Korotkevitch. |
| 264 | 1 | |a [New York, New York] : |b Apress, |c [2015] | |
| 264 | 2 | |a New York, NY : |b Distributed to the Book trade worldwide by Springer Science+Business Media New York | |
| 264 | 4 | |c ©2015 | |
| 300 | |a 1 online resource (1 volume) : |b illustrations. | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 490 | 1 | |a The expert's voice in SQL server | |
| 588 | 0 | |a Online resource; title from title page (Safari, viewed October 27, 2015). | |
| 500 | |a Includes index. | ||
| 505 | 0 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 520 | |a 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. Covers In-Memory OLTP internals and architecture, including data storage, indexing, multi-version concurrency control, transaction logging, and recovery Illustrates In-Memory OLTP programmability and the process of native compilation Guides in using In-Memory OLTP in new development and existing systems. | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a SQL server. |
| 630 | 0 | 7 | |a SQL server. |2 fast |0 (OCoLC)fst01376937 |
| 650 | 0 | |a Database management. | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 7 | |a Database management. |2 fast |0 (OCoLC)fst00888037 | |
| 830 | 0 | |a Expert's voice in SQL server. | |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9781484211366/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 994 | |a 92 |b IZTAP | ||