Understanding Memory with SQL Server and Azure SQL - Bob Ward

Поділитися
Вставка
  • Опубліковано 5 вер 2024

КОМЕНТАРІ • 2

  • @DB-sf1hy
    @DB-sf1hy 2 роки тому +5

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

  • @TehConnon
    @TehConnon 4 роки тому +6

    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