Field Testing Buffer Pool Extension and In Memory OLTP Features
PASS Data Community Summit via YouTube
Overview
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
Taught by
PASS Data Community Summit