Understanding Memory with SQL Server and Azure SQL - Bob Ward

In this session I'll describe how SQL Server memory management works including architecture, limits, and how you can configure and monitor memory usage. I'll also describe differences in memory management for SQL Server on Linux and Azure SQL.

[@DB-sf1hy]

I have watched this maybe 5 times and every time I understand a little bit more.

[@TehConnon]

00:00 Bob's Introduction
03:37 The SQL Server Memory Architecture
08:33 Paging and SQL Server
12:20 Memory Configuration Decisions, and Locked Pages overview
20:51 Dynamic Memory Management visualisation
25:22 Visual look at memory accounting - DMVs, Perfmon, and Task Manager
28:22 Demo: Memory management and Accounting
37:16 Demo: Debugger - How SQL Server uses APIs
41:19 Mid-session Q&A
49:15 Other memory topics: Buffer pool logistics, NUMA, Memory Grants, Memory Leaks
57:47 Plan cache eviction
01:00:45 Linux, Containers, and Kubernetes
01:06:11 Memory for Azure SQL
01:12:38 Final resources and Q&A