SQL Server In-Memory Oltp
Apress
Published on 25. January 2015
Book
Paperback/Softback
250 pages
978-1-4302-6755-3 (ISBN)
Description
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.
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.
More details
Language
English
Place of publication
Berlin
Germany
Publishing group
Springer-Verlag Berlin and Heidelberg GmbH & Co. KG
Target group
Popular/general
Product notice
Paperback (trade)
Unsewn / adhesive bound
Dimensions
Height: 235 mm
Width: 191 mm
Weight
454 gr
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 Classification
Persons
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.
Content
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
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