Abstract
This chapter provides a high-level overview of In-Memory OLTP objects. It shows how to create databases with an In-Memory OLTP filegroup, and how to define memory-optimized tables and access them through the interop engine and natively compiled stored procedures. Finally, this chapter demonstrates performance improvements that can be achieved with the In-Memory OLTP Engine when a large number of concurrent sessions insert the data into the database and latch contention becomes the bottleneck.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2015 Dmitri Korotkevitch
About this chapter
Cite this chapter
Korotkevitch, D. (2015). In-Memory OLTP Objects. In: Expert SQL Server In-Memory OLTP. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1136-6_2
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1136-6_2
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-1137-3
Online ISBN: 978-1-4842-1136-6
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books