SQL Server In-Memory OLTP is your one-stop resource for learning all about the new support in SQL Server 2014 for in-memory online transaction processing. You are now able to create tables and other objects such as indexes that exist only in memory, and never on disk. This is a game-changing feature with ripple effects that extend across the domains of transaction management, performance optimization and scalability, and maintenance and troubleshooting, and and application development.
Formerly known under the code name of "Project Hekaton", in-memory support is the defining new feature of the 2014 release. Database administrators and application designers must become familiar with the feature in order to know when it is best used, and when it is best avoided. Use of in-memory tables and indexes can bring tremendous performance benefits, but then you must know how to manage those objects and how to write applications against them in an optimal manner. SQL Server In-Memory OLTP provides several reference architectures to help you see how in-memory objects can be implemented in different situations. You'll learn how to monitor and troubleshoot in-memory objects, and how to optimize their performance. You'll learn about programming caveats and transaction management.
Support for in-memory objects is a game changer, and their use must at least be considered in all new database and application design work, and when attacking problems of performance and scalability. It is a must-learn feature, and SQL Server In-Memory OLTP provides what you need to know swiftly, accurately, and succinctly.
Sprache
Verlagsort
Verlagsgruppe
Springer-Verlag Berlin and Heidelberg GmbH & Co. KG
Zielgruppe
Produkt-Hinweis
Broschur/Paperback
Klebebindung
Maße
Höhe: 235 mm
Breite: 191 mm
Gewicht
ISBN-13
978-1-4302-6755-3 (9781430267553)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
Jason Brimhall is first and foremost a family man. He has 15+ yrs experience in IT and has worked with SQL Server starting with SQL Server 6.5. He has worked for both large and small companies in varied industries. He has experience in performance tuning, high transaction environments, large environments, and VLDBs. He is currently a DB Architect and an MCITP for SQL 2008. Jason regularly volunteers for PASS and is the VP of the Las Vegas User Group (SSSOLV). You can read more more from Jason on his blog at: http://jasonbrimhall.info.
1. Introduction to In-Memory
2. Database Changes
3. Memory-Optimized Tables
4. Memory-Optimized Indexes
5. Natively-Compiled Stored Procedures
6. Interop Procedures
7. Transaction Isolation and Concurrency
8. Database Backup and Recovery
9. Dynamic Link Libraries
10. Management
11. Migration