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.

Syllabus

Intro
Technical Assistance
Ross LoForte, Rick Heiges
Field Testing Background
Extending the Buffer Pool
Using BPE
BPE - Good Scenarios and Otherwise
Test Configuration
Database Cache
Process More Data
Increase Throughput
Consistent Low Latency is Key
What is SQL Server In-Memory OLTP?
Durability
Integrated Experience
Performance Factors for In-Memory OLTP Data resides in memory at all times
Migration
Demo In-Memory OLTP
Suitable Application Characteristics
Limitations in SQL Server 2014
Interpreting the Results
Overall Performance
Transaction Log Performance
Transaction Logs - Write Megabytes/sec
Transaction Logs - Write Latency (usec)
Database Startup Tests
Memory Optimized File Group
File Group Performance - Checkpoints
Scaling Beyond 12000 Users (24K Users)
Use Cases
Summary
References