Explore memory storage monitoring and troubleshooting techniques for In-Memory OLTP in this 49-minute conference talk from PASS Data Community Summit. Learn how to manage operational challenges such as memory depletion, garbage collection, and corrupt backups. Discover effective use of familiar tools like PerfMon, Profiler, DMVs, XEvents, and Management Pack for workload monitoring. Gain insights into scenarios including memory pressure, automatic garbage collection, resource pool management, and database binding. Witness a live demo covering filestream files, backup processes, data insertion and deletion, and merge guidelines. Enhance your skills in maintaining optimal performance for applications migrated to the In-Memory OLTP Engine.
Overview
Syllabus
Introduction
Request Technical Assistance
Thank Microsoft
PASS Summit 2014
Memory
Garbage Cleanup
Create Database
Create Table
Generation Blocks
Automatic GC Thread
Binding the Database
Testing the Table
Out of Memory
Changing Resource Pool
Memory Pressure
Memory Deletion
OLTP Shock absorbers
Create Resource Pool
Create File Group
Create a Table
Start Interning
Getting close to the line
Automatic GC
Database DDL
Data Merge
Under Construction
Active State
Emerge
Merge Target
Backup Restore
Live Demo
File Explorer
Filestream Files
Backup Files
Insert Data
Active Data
Delete Data
Active Files
Backup File
Merge
Guidelines
Questions
Taught by
PASS Data Community Summit
