Chapter 9In-Memory OLTP
WHAT'S IN THIS CHAPTER?
- Using and implementing in-memory OLTP
- Creating natively compiled stored procedures
- Getting to know the Analyze, Report, and Migrate (ARM) tool
WROX.COM CODE DOWNLOADS FOR THIS CHAPTER
The wrox.com code downloads for this chapter are found at www.wrox.com/go/prosql2014admin on the Download Code tab. The code is in the Chapter 9 download and individually named according to the names throughout the chapter.
In-memory online transaction processing (OLTP) represents one of the most significant changes in SQL Server 2014. To fully appreciate in-memory OLTP, you must understand what the technology is, what it is meant to do, and how it is comparable to other in-memory technologies that are competitors of Microsoft. This holistic view of the technology will enable you to determine if and when you should use in-memory OLTP.
In this chapter, you learn how to create in-memory OLTP tables, how to create natively compiled stored procedures, how in-memory OLTP is integrated into the traditional SQL Server stack, and how to leverage the Analyze, Report, and Migrate (ARM) tool.
USING AND IMPLEMENTING IN-MEMORY OLTP
In-memory OLTP is an enterprise-level feature that brings to businesses and users of all sizes performance that was previously only attainable to organizations that could afford to spend several hundreds of thousands of dollars on hardware. It is available in SQL Server 2014 Developer, Evaluation, and Enterprise editions only. To ...
Get Professional Microsoft SQL Server 2014 Administration now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
