Completed
Intro
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Field Testing Buffer Pool Extension and In Memory OLTP Features
Automatically move to the next video in the Classroom when playback concludes
- 1 Intro
- 2 Technical Assistance
- 3 Ross LoForte, Rick Heiges
- 4 Field Testing Background
- 5 Extending the Buffer Pool
- 6 Using BPE
- 7 BPE - Good Scenarios and Otherwise
- 8 Test Configuration
- 9 Database Cache
- 10 Process More Data
- 11 Increase Throughput
- 12 Consistent Low Latency is Key
- 13 What is SQL Server In-Memory OLTP?
- 14 Durability
- 15 Integrated Experience
- 16 Performance Factors for In-Memory OLTP Data resides in memory at all times
- 17 Migration
- 18 Demo In-Memory OLTP
- 19 Suitable Application Characteristics
- 20 Limitations in SQL Server 2014
- 21 Interpreting the Results
- 22 Overall Performance
- 23 Transaction Log Performance
- 24 Transaction Logs - Write Megabytes/sec
- 25 Transaction Logs - Write Latency (usec)
- 26 Database Startup Tests
- 27 Memory Optimized File Group
- 28 File Group Performance - Checkpoints
- 29 Scaling Beyond 12000 Users (24K Users)
- 30 Use Cases
- 31 Summary
- 32 References