Field Testing Buffer Pool Extension and In Memory OLTP Features
Explore the powerful new features of SQL Server 2014 in this informative conference talk from PASS Data Community Summit. Dive into field benchmark results and customer examples of In-Memory OLTP (Codename "Hekaton") and Buffer Pool Extension (BPE) features. Learn how these technologies can significantly boost performance by leveraging today's powerful processors and fast solid-state storage. Discover the behavior, scalability, and ideal use cases for each feature through comprehensive testing conducted at MTC Chicago. Gain insights into extending the buffer pool, increasing throughput, and achieving consistent low latency. Understand the integrated experience, durability aspects, and performance factors of In-Memory OLTP. Examine suitable application characteristics, limitations in SQL Server 2014, and interpret detailed performance results, including transaction log performance and database startup tests. Explore real-world use cases and gather valuable references to enhance your SQL Server implementation. Read more