Field Testing Buffer Pool Extension and In Memory OLTP Features

Field Testing Buffer Pool Extension and In Memory OLTP Features

PASS Data Community Summit via YouTube Direct link

Intro

1 of 32

1 of 32

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.