SQL Server In-Memory Oltp

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 isthedefining 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 OLTPprovides 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. What you'll learn Understand the in-memory architecture and its implications. Create and manage tables and indexes using the new architecture. Write applications and T-SQL procedural code to best take advantage of in-memory support. Properly manage transactions under the new architecture. Migrate to and from, and interoperate between, in-memory and on-disk tables. Monitor and optimize performance improvements from in-memory objects.Who this book is for SQL Server In-Memory OLTP is a must-read book for SQL Server administrators and those who design and develop applications running against SQL Server databases. Professionals working closely with SQL Server need to understand the new, in-memory support and its benefits, to know when it should be used, and be able to monitor and optimize the systems that use it. "