Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Field Testing Buffer Pool Extension and In Memory OLTP Features

PASS Data Community Summit via YouTube

Overview

This course aims to teach learners about the Field Testing Buffer Pool Extension and In-Memory OLTP features in SQL Server 2014. By the end of the course, students will understand the behavior, scalability, and use cases of these features. The course covers topics such as extending the Buffer Pool, scenarios for using BPE, performance factors for In-Memory OLTP, suitable application characteristics, limitations in SQL Server 2014, and interpreting benchmark results. The teaching method includes technical assistance, field testing background, demonstrations, and real-world customer examples. This course is intended for SQL Server developers, database administrators, and IT professionals looking to enhance their performance optimization skills.

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

Reviews

Start your review of Field Testing Buffer Pool Extension and In Memory OLTP Features

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.